ZorantaGuides
Clocktape

Clocktape › Guides

How to Calculate Hours Worked Overnight (Shifts Past Midnight)

To calculate hours worked overnight, add 24 hours to the end time, then subtract the start time. A shift from 22:00 to 6:15 is (6:15 + 24:00) − 22:00 = 8:15. Take off an unpaid 30-minute break and the hours worked are 7:45.

The usual mistake is subtracting the other way round, 22:00 − 6:15 = 15:45, which is the time you were off, not the time you worked.

A moon and a rising sun joined by a strip of paper tape

How to calculate hours worked overnight

  1. Write both times in 24-hour form. 10:00 pm is 22:00 and 6:15 am is 6:15.
  2. Check whether the end is earlier than the start. If it is, the shift crossed midnight.
  3. Add 24:00 to the end time. 6:15 becomes 30:15.
  4. Subtract the start. 30:15 − 22:00 = 8:15.
  5. 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

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

ShiftCalculationLengthUnpaid breakWorked
22:00 → 6:1530:15 − 22:008:150:307:45
21:30 → 7:0031:00 − 21:309:300:458:45
23:00 → 7:3031:30 − 23:008:300:308:00
19:00 → 7:0031:00 − 19:0012:001:0011:00
16:00 → 0:3024:30 − 16:008:300:308: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:

Test the sheet on a shift you already know: 22:00 to 6:15 with a 0:30 break should give 7.75.

This page covers time arithmetic, not payroll or legal advice. How night hours, breaks and sleep time are paid depends on your employer and local law; check the official guidance or ask your payroll team.
Clocktape

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 Play

iPhone version coming soon

More guides

All guides

Sources

Published by Zoranta, the developer of Clocktape.