Skip to content
Tools.Town
290+ free online tools

Real-world workflow

Use Case

Timesheet Hours for an Overnight Shift

Calculate worked hours when a shift crosses midnight — spans-midnight duration, multi-segment breaks, and common off-by hours mistakes.

16 August 2026 By Tools.Town Team 5 min read

The problem

Night shifts start before midnight and end after it. Spreadsheet formulas that subtract end − start without a day boundary under-count or show nonsense. Breaks make it worse if you subtract first punch from last punch and forget unpaid time.

Who this is for

Contractors, clinic/hospital staff, warehouse teams, and anyone logging overnight hours without payroll software.

Steps

  1. Write each worked segment as start clock → end clock.
  2. Open the Time Duration Calculator.
  3. For a single overnight segment (e.g. 22:00–06:00), enter both times and enable spans midnight.
  4. For a shift with a break, use multi-segment mode: morning/evening pieces separately, then sum.
  5. Copy the total hours and minutes into the timesheet.

Example

Shift: 22:00–02:00 and 02:30–06:00 (30-minute unpaid break).

  • Segment A (spans midnight): 4h 00m
  • Segment B: 3h 30m
  • Total worked: 7h 30m

Subtracting 22:00 from 06:00 as one block would incorrectly include the break.

Frequently Asked Questions

Why is 23:00 to 07:00 not eight hours in a naive subtract?

Without a midnight rule, end looks earlier than start and the math goes negative or wraps incorrectly. Enable spans midnight (or attach dates).

Should unpaid breaks be included?

Only if policy says so. Prefer two segments around the break and sum them.

Is Date Difference the right tool?

No for HH:MM timesheets. Use Time Duration. Date Difference is for calendar intervals.