Decimal Hours for Timesheets and Payroll

Quick answer: Decimal hours make rate-based calculations straightforward because hours and currency can be multiplied as ordinary numbers.

Try it: Open the free BuzBolt Time Calculator. No signup is required.

Understand the method

Compute work minutes first, subtract unpaid minutes, then divide the net minutes by 60. Keep raw minute totals where possible so the record can be checked later.

Pay and rounding rules depend on contract and jurisdiction. A calculator shows arithmetic, not whether overtime, breaks or premium rates apply.

Worked example

A shift of 8 hours 20 minutes is 500 minutes, or approximately 8.3333 decimal hours. At an illustrative £18 per hour, the unrounded calculation is 500 ÷ 60 × 18 = £150.

What people often get wrong

If you round 8.3333 to 8.33 before multiplying, you get £149.94 rather than £150. Precision and rounding order matter.

A practical way to use this

Keep raw minutes in a hidden or visible spreadsheet column and round the final monetary amount according to your accounting requirements.

Frequently asked question

Can timesheet decimal hours exceed 24? Yes, a weekly total commonly does.

Keep timesheets auditable

A timesheet can store the original start and end clock times, the break in minutes, and a calculated decimal-hours result. If the total looks wrong, the original inputs are still available for checking. That is more reliable than keeping only a rounded decimal number.

Apply it to your own task

For a 7-hour 20-minute net shift, the exact decimal is 7.3333… hours. Displaying 7.33 is useful for a summary, but the underlying calculation should use the full value where possible. This is a numerical accuracy principle, not a payroll rounding policy.