How to calculate hours worked overnight
- Write both times in 24-hour form. 10:00 pm is 22:00 and 6:15 am is 6:15.
- Check whether the end is earlier than the start. If it is, the shift crossed midnight.
- Add 24:00 to the end time. 6:15 becomes 30:15.
- Subtract the start. 30:15 − 22:00 = 8:15.
- Take off unpaid breaks. 8:15 − 0:30 = 7:45.
The other way: split at midnight
Some people find it easier to work out the two halves. From 22:00 to midnight is 2:00. From midnight to 6:15 is 6:15. Together that is 8:15, the same answer. Splitting is also how you handle a different pay rate for the hours after midnight, if your employer uses one.
Clocktape crosses midnight on its own: type 22:00 → 6:15 − 0:30 on one line and it shows 7:45. Get it on Google Play
Night shift hours: worked examples
| Shift | Calculation | Length | Unpaid break | Worked |
|---|---|---|---|---|
| 22:00 → 6:15 | 30:15 − 22:00 | 8:15 | 0:30 | 7:45 |
| 21:30 → 7:00 | 31:00 − 21:30 | 9:30 | 0:45 | 8:45 |
| 23:00 → 7:30 | 31:30 − 23:00 | 8:30 | 0:30 | 8:00 |
| 19:00 → 7:00 | 31:00 − 19:00 | 12:00 | 1:00 | 11:00 |
| 16:00 → 0:30 | 24:30 − 16:00 | 8:30 | 0:30 | 8:00 |
Four nights from the first four rows add up to 7:45 + 8:45 + 8:00 + 11:00. Hours: 7 + 8 + 8 + 11 = 34. Minutes: 45 + 45 + 0 + 0 = 90, which is 1:30. The total is 35:30, or 35.50 decimal hours.
A shift that ends exactly at midnight is 24:00 for the end time. 16:00 → 0:00 is 24:00 − 16:00 = 8:00.
Overnight shifts with breaks
Subtract the break after you have the full length of the shift, not before. It does not matter when in the night the break happened, unless you are splitting hours between pay rates.
When you are splitting, place the break in the half where it fell. Take the 22:00 → 6:15 shift with a night rate from 23:00. The hours before 23:00 are 1:00 and the hours after are 7:15. If the 30-minute meal break was at 2:00, it comes off the later part: 1:00 at the day rate and 6:45 at the night rate, 7:45 in total.
In the United States, the Department of Labor's page on breaks and meal periods explains which breaks federal rules treat as paid time. Short rest breaks are generally counted as work; a real meal period where you are relieved from duty generally is not.
Which day does an overnight shift belong to?
A shift from Friday 22:00 to Saturday 6:15 touches two dates. For your own records, it is simplest to put the whole shift on the day it started. For pay, employers decide this in their timekeeping rules, and it matters when a shift crosses the start of a new workweek, because the hours can end up in different weeks for overtime.
Very long shifts have their own rules. For shifts of 24 hours or more, U.S. federal guidance in Fact Sheet #22 on hours worked describes when scheduled sleep time can be left out by agreement. Check with your employer before subtracting any sleep time yourself.
The night the clocks change
Where clocks move for daylight saving time, an overnight shift on that night is an hour longer or shorter on the wall clock than in real time. The 24-hour method above assumes the clocks did not move, so adjust that one shift by an hour.
Excel and Google Sheets formula for overnight hours
Spreadsheets store times as fractions of a day, so an end time after midnight looks smaller than the start. Two formulas handle it, with the start in A2 and the end in B2:
=MOD(B2-A2,1)*24gives decimal hours for any shift shorter than 24 hours.=IF(B2<A2,B2+1-A2,B2-A2)gives the length as a time; format the cell as[h]:mm.- To take off a break in C2 (entered as a time, such as 0:30), use
=(MOD(B2-A2,1)-C2)*24.
Test the sheet on a shift you already know: 22:00 to 6:15 with a 0:30 break should give 7.75.
Log a run of night shifts
Put one shift on each line of a Clocktape tape, name the lines by day, and the total for the run stays at the bottom.
Get it on Google PlayiPhone version coming soon
More guides
- How to Calculate Hours Worked: Start, End, Breaks and Weekly TotalCalculate hours worked from start and end times: subtract, take off unpaid breaks, add the days, then convert to decimal hours. A full worked week included.
- Minutes to Decimal Hours: Formula and Conversion ChartConvert minutes to decimal hours by dividing by 60. Full chart from 1 to 60 minutes, the reverse conversion, rounding to 1, 2 or 3 places, and common time card mistakes.
- Adding Hours and Minutes Together (and Subtracting Them)Add hours and minutes by adding each part, then carrying every 60 minutes into an hour. Examples for subtracting, totals over 24 hours, seconds, and multiplying time.
- How to Calculate Overtime Hours from a Time CardOvertime hours are the hours worked beyond your threshold. Total the week in hours and minutes, subtract the threshold, convert to decimals, check daily and weekly rules.
Published by Zoranta, the developer of Clocktape.