Time Card Maths: Minutes, Decimals and Overtime
Why 8:30 is not 8.30, how punch rounding and the seven-minute rule really work, and the order of operations payroll gets wrong on overtime.
A payroll clerk once paid me for 7.50 hours when I had worked 7 hours 50 minutes. Twenty minutes, one pay period, nobody acting in bad faith. The card said 7:50 and somebody typed 7.50. Then it happened again the next month.
That is the whole problem with weekly time cards in one line. Minutes run in sixties. Decimal hours run in hundredths. Almost every error on a hand-added card traces back to someone mixing the two.
8:30 is 8.5, and it is never 8.30
Divide the minutes by 60. Half an hour is 0.5. Forty-five minutes is 0.75. Ten minutes is 0.1666…, which rounds badly, and that is exactly why payroll systems like six-minute increments: six minutes is a clean 0.1.
The dangerous values are the ones that look plausible either way. 8.15 and 8:15 are six minutes apart. 8.45 and 8:45 are twenty-four minutes apart. Spread that across a ragged five-day week and you can lose an hour without a single digit looking wrong.
The Time Card Calculator puts both columns next to each other on every row, so you see the pair rather than having to remember to check.
The Friday night problem
Ask a spreadsheet for 06:00 minus 22:00 and it reports minus sixteen hours. Anyone who has built a time card in Excel has met a negative Friday.
The fix is arithmetic, not a formula trick. If the clock-out is earlier than the clock-in, the shift ran into the next day, so add 24 hours before subtracting: 22:00 to 06:00 is eight hours. The calculator spots that case on its own and tags the row with +1d, so you can tell it made the decision instead of quietly guessing.
Overtime has an order of operations
Where a daily and a weekly threshold both apply, as in California, Alaska, Nevada and much of Europe, the daily count comes first and those hours are then excluded from the weekly count.
Worked example. Four days of ten hours, nothing on Friday.
- Daily: two hours past the 8-hour mark, four times over. Eight hours of overtime.
- Regular hours left: 32.
- Weekly: 32 is under 40, so the weekly rule adds nothing.
Final answer, 32 regular and 8 overtime. Count weekly only and you get 40 regular with no overtime at all, which underpays by eight hours at time and a half. Count both without the exclusion and you pay 48 hours for a 40-hour week. The order is not a detail.
Rounding, and the seven-minute rule
US employers may round punches to increments of up to 15 minutes, provided the rounding stays neutral over time. Hence the seven-minute rule: 8:07 drops back to 8:00, 8:08 jumps forward to 8:15.
Two things get missed. Rounding applies to each punch before the subtraction, not to the daily total, and rounding the total gives a different number. And it has to cut both ways. Rounding clock-ins up while rounding clock-outs down has cost employers real money in wage-and-hour claims.
Count the lunch once
There are two ways to record an unpaid break, and people cheerfully use both at the same time. Either the employee clocks out and back in, in which case the second punch pair handles it and the gap falls out by itself, or the break is a flat deduction and the minutes go in the Break column.
Do both for the same lunch and you subtract that half hour twice. By Friday it is two and a half hours of pay, gone.
Fill in your week and see where the card actually lands: Time Card Calculator.