Timesheet Math: Decimal Hours, Breaks, and Night Shifts
Why 8:15 on the clock becomes 8.25 on the payslip, how to count shifts that cross midnight, and the rounding rules that quietly reshape your hours.
If you’ve ever typed “8.15” into timesheet software after working eight hours and fifteen minutes, you’ve underbilled yourself by six minutes. Decimal hours and clock time look alike, behave differently, and payroll systems only speak one of them. That mismatch is behind most timesheet disputes I’ve seen, and it’s entirely avoidable.
Clock time vs decimal hours
Clock notation counts minutes out of 60; decimal notation counts fractions of an hour out of 100. So:
- 8:15 = 8.25 hours
- 8:30 = 8.5 hours
- 8:45 = 8.75 hours
- 8:20 = 8.33 hours (20 ÷ 60, rounded)
The conversion is minutes ÷ 60. It only feels obvious for the quarter-hour marks. 8:09 becomes 8.15 — which is exactly why typing your clock time into a decimal field goes wrong silently. Payroll multiplies decimal hours by your rate; at $25/hour, the 8.15-vs-8.25 slip costs $2.50 every single day it happens.
The Time Duration Calculator shows both formats side by side, plus total minutes, so whichever field your software has, you copy the right number.
Breaks come out before the math
Most jurisdictions treat lunch as unpaid, so a 9:00–17:30 day with a 30-minute break is 8 paid hours, not 8.5. The order of operations matters when you calculate by hand: subtract the break from total minutes first, then convert to decimal. People sometimes convert first and subtract 0.30 (instead of 0.5) for a half-hour lunch — the same digits-versus-minutes confusion in a different coat.
The midnight problem
Subtract 22:00 from 06:00 naively and you get −16 hours. Every timesheet has faced this at least once. The fix: when the end time is earlier than the start, add 24 hours before subtracting. A 22:00–06:00 night shift is 8 hours; 23:30–07:15 is 7 hours 45 minutes. The calculator detects this automatically and flags the span as overnight, which doubles as a sanity check — if you see the overnight note on a day shift, one of your times has a typo.
Rounding rules exist, and they’re not neutral
In the US, federal rules let employers round punches to the nearest quarter hour under the “7-minute rule”: clocking in from 7:53 to 8:07 records as 8:00. Rounding must go both ways — always rounding in the employer’s favour has repeatedly lost in court. If your employer rounds, track your actual punches for a couple of weeks and compare. The difference between real time and rounded time over a month is often under 30 minutes, but “often” is not “always”, and you can only tell by counting.
A few habits that keep timesheets clean:
- Record actual clock times, not remembered ones; reconstruct the duration afterwards.
- Convert once, at the end of the day, not per-entry in your head.
- For overnight shifts, write the date next to the end time.
- Keep the decimal total to two places — that’s what payroll systems store anyway.
Whether you’re tallying a week of shifts or checking that an invoice matches the hours behind it, the Time Duration Calculator gives you the duration, the decimal conversion, and midnight handling in one place — nothing to install, nothing uploaded.