The calculation
- Write both times on a 24-hour clock: 10:00 PM is 22:00, 6:30 AM is 06:30.
- If the end is earlier than the start, add 24 to the end: 06:30 becomes 30:30.
- Subtract: 30:30 − 22:00 = 8:30.
- Take off any unpaid break: 8:30 − 0:30 = 8:00.
- Convert to decimal if payroll needs it: 8:00 = 8.00, 7:45 = 7.75.
The time card calculator does this automatically: a clock-out earlier than the clock-in is read as the next morning.
Which day the hours belong to
For the schedule and the timesheet, most businesses put the whole shift on the day it started. A Friday night shift is "Friday" to everyone, even though most of it is Saturday morning. That's fine until the shift crosses the end of your workweek.
When the shift crosses the end of the workweek
Overtime under the federal rules is counted per fixed workweek of 168 hours. If your workweek ends at midnight Saturday and someone works Saturday 22:00 to Sunday 06:30, the 2 hours before midnight fall in this week and the 6.5 after fall in next week (less any break, in the week it was taken).
| Hours | Before midnight | After midnight |
|---|---|---|
| Saturday 22:00 to Sunday 06:30 | 2.0 (this week) | 6.5 (next week) |
| 30-minute break at 02:00 | −0.5 (next week) | |
| Counted | 2.0 | 6.0 |
Splitting matters when someone is close to 40 in either week. Many employers set the workweek to end at a quiet time, such as Sunday 06:00 for a business with Saturday night shifts. The workweek has to be fixed and can't be changed to avoid overtime.
In a spreadsheet
Use =MOD(end−start,1)*24 for hours. MOD adds a day whenever the end is earlier than the start. How to make an employee schedule in Excel walks through the full sheet.