5 Common Decimal Hours Mistakes (and How to Catch Them)
Decimal hours are simple arithmetic, but a small set of mistakes account for nearly every payroll or invoicing error involving them. All five are easy to catch once you know what to look for.
1. Treating minutes like cents
45 minutes is not 0.45 of an hour — it's 0.75. Minutes are a fraction of 60, not 100. If a converted value ends in .10, .15, .20, .30, .40, or .45 for a "round-looking" number of minutes, double-check it wasn't typed directly instead of converted.
2. Forgetting seconds entirely
Time clock exports sometimes include seconds that get silently dropped during manual conversion. Across a single entry it's negligible; summed across a two-week pay period for an hourly team, a consistently dropped 20–30 seconds per punch can shift a total by several minutes.
3. Rounding twice
Rounding each entry to the nearest quarter hour, then rounding the summed total again, compounds error in a way a single rounding step doesn't. Round once — ideally at the final total, not per entry — for the most accurate result.
4. Mixing 12-hour and 24-hour punches
A clock-out of "5:00" is ambiguous without AM/PM or 24-hour format. Overnight shifts are the most common place this breaks silently, producing a negative or wildly wrong duration if the format isn't consistent on both ends.
5. Applying an hourly rate to HH:MM directly
7:45 × an hourly rate is not the same number as 7.75 × that rate, even though they represent the same duration. Any multiplication involving a time duration needs the decimal form first — this is the single most common source of payroll math errors.
Leave a Reply