How to Calculate Work Hours With Breaks and Overnight Shifts

1. The Problem With Midnight Crossing

Calculating hours for standard daytime shifts is straightforward: a worker clocking in at 9:00 AM and out at 5:00 PM worked 8 hours. However, night and graveyard shifts present a common mathematical trap for payroll managers and spreadsheets:

• Clock In: 10:00 PM (22:00)
• Clock Out: 6:30 AM (06:30) next morning

A simple subtraction (6.5 − 22.0) produces −15.5 hours. Because the clock resets to 00:00 at midnight, calculations that do not account for day transitions fail.

The Overnight Adjustment Rule

To resolve overnight shifts mathematically, add 24 hours (1,440 minutes) to the checkout time whenever Clock Out is numerically less than Clock In:

In our example: 06:30 + 24:00 = 30:30 (1,830 minutes). Subtracting 22:00 (1,320 minutes) gives 510 minutes, which equals 8 hours and 30 minutes.

2. Paid Rest Breaks vs. Unpaid Meal Breaks

Accurate payroll requires distinguishing between compensable rest periods and non-compensable meal breaks under labor standards (such as the U.S. Fair Labor Standards Act — FLSA):

These are general U.S. federal principles; federal law does not require employers to provide meal or rest breaks. A meal period is generally unpaid only when the employee is completely relieved from duty. State rules, employment terms, and the facts of a particular break can change how time is treated. See the U.S. Department of Labor guidance on breaks and meal periods.

3. Converting Minutes to Decimal Hours for Payroll

When using a decimal-hour payroll calculation, convert minutes to a fraction of an hour first. An employee who worked 8 hours and 30 minutes at $20/hr has 8.5 hours for this calculation, not 8.30 hours. Multiplying by 8.30 would produce $4.00 less pay in this example.

4. Worked Example: Five Overnight Shifts

Consider an employee working five overnight shifts during one fixed 168-hour workweek. For this arithmetic example, assume a $24.00 hourly base rate and 1.5× overtime pay for hours above 40; the example treats $24.00 as the applicable regular rate. Actual overtime rules and rates depend on worker coverage, classification, other compensation, and applicable law. A U.S. federal workweek is a fixed, recurring period of seven consecutive 24-hour days; it does not have to start on Monday. See the Department of Labor's overtime guidance.

• Monday: 21:00 to 05:30 (Next day) − 30 min meal break = 8.00 hrs
• Tuesday: 21:00 to 05:30 (Next day) − 30 min meal break = 8.00 hrs
• Wednesday: 21:00 to 07:00 (Next day) − 45 min meal break = 9.25 hrs
• Thursday: 21:00 to 07:30 (Next day) − 45 min meal break = 9.75 hrs
• Friday: 21:00 to 06:00 (Next day) − 30 min meal break = 8.50 hrs

The add-24-hours shortcut assumes ordinary elapsed time between the listed clock times. If a shift crosses a daylight-saving clock change, use the actual recorded timestamps and applicable payroll records because local clock labels alone may not show elapsed hours.

Total Hours Worked: 8.00 + 8.00 + 9.25 + 9.75 + 8.50 = 43.50 hours.

• Regular Hours: 40.00 hrs × $24.00 = $960.00
• Overtime Hours: 3.50 hrs × ($24.00 × 1.5) = 3.50 × $36.00 = $126.00
• Total Gross Pay: $960.00 + $126.00 = $1,086.00

Related Payroll & Time Tracking Tools

Check a schedule or compare pay scenarios with these related tools:

• Overtime Pay Calculator — Calculate 1.5× and double-time earnings accurately.
• Salary ↔ Hourly Calculator — Compare hourly wages with equivalent gross salary figures.

Explore related tools in Work & Pay.