Work Day Definition Example
This example shows the differences between the earned day definition (ActualDate) and overtime day definition (RefDate).
The earned day definition(ActualDate) has the spanning days rule as Start day and the grouping threshold as 180 minutes.
- For any time entry that crosses midnight, the ActualDate is the date of the entry StartTime. For example, if the StartTime is 2019-Nov-10 07:00, then the ActualDate is 2019-Nov-10.
- For any time entry that starts less than 180 minutes after the previous entry stops, the ActualDate is the date of the previous entry's StartTime.
The overtime day definition has the day start time as 5:00p of the current day. For any time entry between 5:00p today and 5:00p tomorrow, the RefDate is today's date. For example, the RefDate for the entry 2019-Nov-12 13:00 to 2019-Nov-12 16:00 is 2019-Nov-11.
For any time entry that starts before and stops after 5:00p, the entry is split between the previous and current days, or yesterday and today. For example, the entry 2019-Nov-12 15:00 to 2019-Nov-12 19:00 is split into 2 entries: 2019-Nov-12 15:00 to 2019-Nov-12 17:00 and 2019-Nov-12 17:00 to 2019-Nov-12 19:00 The RefDate is 2019-Nov-11 for the first entry and 2019-Nov-12 for the second entry.
Sample Time Cards
The time card period for this time card is November 4 through 10, 2019. The person reported time for only Sunday, 10 November.
Day | Payroll Time Type | Start Time | Stop Time |
---|---|---|---|
Sun, Nov 10 | Regular |
7:00a 6:00p |
4:00p 3:00a |
The time card period for this time card is November 11 through 17, 2019. The person reported time for Monday through Wednesday, November 11 through 13.
Day | Payroll Time Type | Start Time | Stop Time |
---|---|---|---|
Mon to Tue Nov 11 to 12 |
Regular |
5:00a 1:00p 6:00p |
7:00a 5:00p 3:00a |
Wed, Nov 13 | Regular | 5:00a | 7:00a |
Generated ActualDates and RefDates
These generated ActualDates and RefDates are passed to time calculation formulas for processing. The bolded ActualDates and RefDates are both the same as the date of the start time, even though the date of the stop time is the next day. The measure (also known as quantity) is the duration between entry start and stop times.
Start Time | Stop Time | Measure | Payroll Time Type | ActualDate | RefDate |
---|---|---|---|---|---|
2019-Nov-10 07:00 | 2019-Nov-10 16:00 | 9h | Regular | 2019-Nov-10 | 2019-Nov-9 |
2019-Nov-10 18:00 | 2019-Nov-11 03:00 | 9h | Regular | 2019-Nov-10 | 2019-Nov-10 |
2019-Nov-11 05:00 | 2019-Nov-11 07:00 | 2h | Regular | 2019-Nov-11 | 2019-Nov-10 |
2019-Nov-11 13:00 | 2019-Nov-11 17:00 | 4h | Regular | 2019-Nov-11 | 2019-Nov-10 |
2019-Nov-11 18:00 | 2019-Nov-12 03:00 | 9h | Regular | 2019-Nov-11 | 2019-Nov-11 |
2019-Nov-12 05:00 | 2019-Nov-12 07:00 | 2h | Regular | 2019-Nov-11 | 2019-Nov-11 |
2019-Nov-12 13:00 | 2019-Nov-12 17:00 | 4h | Regular | 2019-Nov-12 | 2019-Nov-11 |
2019-Nov-12 18:00 | 2019-Nov-13 03:00 | 9h | Regular | 2019-Nov-12 | 2019-Nov-12 |