Five Mistakes That Throw Off a Weekly Time Card
· 5 min read
You add up a week of hours, write a number on the time card, and someone questions it. Now you are re-checking eleven entries against your memory of who left when. Most weekly totals go wrong in the same five ways. Each one is easy to spot once you know the shape of it.
1. A forgotten clock-out runs to the current time
This is the most common error by a wide margin. A worker clocks in at 9:00 a.m. Friday and never clocks out. By the time you pull the sheet on Monday, that entry has been open for 71 hours. If your tool closes the entry at the moment you look at it, you just billed someone for the whole weekend.
It hurts because it is invisible. A 71-hour line looks like a data glitch and gets noticed, but a forgotten clock-out that runs an extra 4 hours into the evening looks plausible. You pay it, or you guess at a correction and hope you guessed right.
The fix is to cap open entries at a sensible length instead of the present moment. Kangaroo Clock uses an auto-close rule for forgotten clock-outs that closes a stale entry at its start time plus a cutoff, never at the current time. A missed clock-out tops out at, say, a normal shift length instead of inflating to days. When you do find one, scan the day's entries for any single line longer than a real shift and correct it at the source before you total anything.
2. Adding minutes as if they were decimals
Someone works 7 hours and 45 minutes. On the card it reads 7.45. Then it gets multiplied by a pay rate, and the worker is short, because 45 minutes is 0.75 of an hour, not 0.45. The gap is small per shift and adds up fast across a week and a crew.
This happens whenever people record time in hours and minutes but treat the minutes column as a decimal. The two formats look almost identical on paper. The conversion is mechanical: divide minutes by 60. Fifteen minutes is 0.25, twenty minutes is 0.333, fifty minutes is 0.833.
The fix is to convert once, deliberately, and keep one format end to end. A payroll hours converter for decimal and HH:MM does the swap without you doing arithmetic in your head, and the definition of decimal hours is worth a quick read if your team mixes the two. Pick decimal for anything that gets multiplied by a rate.
3. Shifts that cross midnight collapse to a negative or huge number
An event crew clocks in at 8:00 p.m. and out at 1:30 a.m. Subtract the clock-in time from the clock-out time the naive way and you get 1:30 minus 20:00, which lands at negative 18.5 hours. Spreadsheets handle this differently depending on whether a date is attached, so you sometimes get a wild positive number instead. Either way the total is wrong.
The trouble is that a bare time has no date. 1:30 alone cannot tell whether it is the same day or the next one. If your records store only the clock time, every overnight shift is a manual judgment call.
The fix is to store full timestamps, not times. Kangaroo Clock records each entry with a date and stores everything in UTC, then shows it in your local time, so an overnight shift is just a start and an end that happen to span midnight. The math works without a special case. If you are summing overnight shifts by hand, write the date next to each time so the subtraction has something to lean on.
4. Breaks counted twice, or not at all
A worker clocks out for a 30-minute lunch and clocks back in. That is correct. The mistake comes when you also subtract a 30-minute break from the same shift as a policy default, so lunch gets deducted twice. The reverse is just as common: the shift includes an unpaid break that nobody removed, so paid time runs 30 minutes long every day.
Across five shifts, a double-counted half hour is 2.5 hours in either direction. That is real money and a real argument with a worker who knows what they actually worked.
The fix is to decide once how breaks are handled and apply it consistently. If workers clock out for lunch, do not also deduct a default break. If they stay clocked in through lunch, deduct it once. A lunch-break time calculator helps you see the paid total after the break so you are not deducting the same thirty minutes twice.
5. Rounding each entry, then rounding the total
You round every clock-in and clock-out to the nearest quarter hour, then round the weekly total again at the end. Each rounding step nudges the number, and the steps stack. A worker who clocked 38 hours and 52 minutes can land at 38.75 or 39.25 depending on where you round, and the two answers disagree by half an hour.
Rounding is not wrong by itself, but rounding at two levels is. The drift is unpredictable and it is hard to explain when someone asks how you got the number.
The fix is to keep raw minutes for every entry, sum the raw minutes for the week, and round once at the very end if you round at all. Run the week through a tool that totals a weekly time card from exact in and out times so the only rounding happens on the final figure, in one place you can point to.
Catch all five before the total leaves your desk
Four of these five mistakes disappear when the underlying records are clean: full timestamps, a sane cap on open entries, one format for hours, and one rounding step. That is most of what a login-free time clock gives you. Workers tap a name or open a link, the entry carries a real date and time, and you export a CSV with a stable column layout that you total the same way every week. Start a free workspace and run one week through it before payroll, then check the longest entry, the break handling, and the final round. If those three are right, the total is right.
Tags: time tracking, payroll, mistakes, timesheets
See it in your own setup
No signup needed. Add a few names, share a kiosk URL, watch hours land.