24-Hour Shift Timesheet Template
Ordinary timesheets break at midnight \u2014 a 10 PM to 6 AM shift computes as negative eight hours. This one doesn't: the hours formula wraps past midnight, so overnight and rotating shifts total correctly, a shift column labels each row day, swing, or night, and a night-hours column feeds a differential pay line at whatever percent your workplace pays. Overtime still splits at 40 per workweek; a shift belongs to the day it starts.
The round-the-clock sheet, three ways.
Midnight is where timesheet math goes wrong.
Most spreadsheet timesheets subtract time-in from time-out, which works until the shift ends on a different calendar day and the result goes negative or wraps to nonsense. Healthcare, security, manufacturing, and hospitality run around the clock and have quietly hand-corrected that error for decades. The formula here wraps at 24 hours by construction, so the night shift totals eight without anyone fixing it.
Write the differential window into the sheet’s header when you issue it — “Night hours = 11 PM to 7 AM” — so staff count the same hours the same way. Differential disputes are almost always about the window, not the percent.