How to Calculate Work Hours for Payroll
Calculating your weekly timesheet seems simple until you have to deal with odd starting times, unpaid lunch breaks, and overnight shifts. The biggest mistake employees and freelance contractors make is confusing standard "Clock Time" (Hours and Minutes) with "Decimal Hours" used by accounting software.
Hours & Minutes
This is how humans read time. If you work from 9:00 AM to 5:30 PM, you have worked 8 hours and 30 minutes. However, you cannot multiply an hourly rate by "8.30" because there are 60 minutes in an hour, not 100!
Decimal Hours
This is how payroll software reads time. It converts the minutes into a percentage of a full hour. Since 30 minutes is exactly half of an hour, 8 hours and 30 minutes converts to 8.50 Decimal Hours. This is the number you multiply by your hourly wage.
The Conversion Formula
If you need to manually convert your minutes into decimals for an invoice, the math is very straightforward:
Decimal Hours = Minutes ÷ 60
Common Conversions:
• 15 Minutes = 0.25 Hours
• 30 Minutes = 0.50 Hours
• 45 Minutes = 0.75 Hours
Handling Overnight Shifts
One of the most frustrating things to calculate manually is a "Night Shift" that crosses midnight. For example, if you start at 10:00 PM and finish at 6:00 AM.
Our calculator automatically detects if your End Time is mathematically "earlier" than your Start Time and safely assumes the shift ended on the following day, perfectly calculating the 8-hour total without throwing an error.
Pro Tip: Rounding Rules
In many countries, labor laws allow employers to round your clock-in/clock-out times to the nearest 15 minutes (the "7-Minute Rule"). If you clock in at 8:07 AM, it may be rounded down to 8:00 AM. If you clock in at 8:08 AM, it may be rounded up to 8:15 AM. Always check your local labor laws or HR policy.