Key Takeaways
- Calculate net work hours by subtracting start time and unpaid breaks from your end time.
- Convert minutes to decimals (minutes ÷ 60) for accurate timesheets and payroll reporting.
- For overnight shifts, split and calculate the hours worked before and after midnight separately.
Calculating work hours looks simple until breaks, overnight shifts, decimal hours, overtime, and weekly totals get mixed together. The good news is that the core method stays the same: measure the time between clock-in and clock-out, then subtract any unpaid time.
The Basic Work Hours Formula
Use this formula for a normal shift:
For example, if you start at 9:00 AM and finish at 5:30 PM, the total time is 8 hours and 30 minutes. If you took a 30-minute unpaid lunch, your paid work time is 8 hours.
Step-by-Step Method
- Write down the start time. Use the exact clock-in time, such as 8:45 AM.
- Write down the end time. Use the exact clock-out time, such as 5:15 PM.
- Find the total time between them. In this example, 8:45 AM to 5:15 PM equals 8 hours and 30 minutes.
- Subtract unpaid breaks. If lunch was 45 minutes, the paid total is 7 hours and 45 minutes.
- Convert minutes to decimals if needed. Payroll systems often use decimals, so 7 hours 45 minutes becomes 7.75 hours.
How to Convert Minutes to Decimal Hours
To convert minutes to decimal hours, divide the minutes by 60 and add the result to your full hours.
Here are common conversions: 15 minutes is 0.25 hours, 30 minutes is 0.5 hours, and 45 minutes is 0.75 hours. So 6 hours and 30 minutes should be entered as 6.5 hours for payroll calculations.
Handling Overnight Shifts
For shifts that pass midnight, count the time until midnight first, then add the time after midnight. A shift from 10:00 PM to 6:00 AM is 2 hours before midnight plus 6 hours after midnight, which equals 8 total hours. After subtracting unpaid breaks, you have the net work hours.
Weekly Timesheet Totals
Once each shift is calculated, add the daily totals together. This is the number most people need for a weekly timesheet. If you work different schedules each day, calculate each day separately before adding them. This keeps break deductions and partial shifts accurate.
When to Use Overtime and Payroll Calculations
After you know your total hours, you can estimate pay. For regular pay, multiply hours by your hourly rate. For overtime, separate regular hours and overtime hours first, then apply the correct overtime multiplier. Rules vary by location and employer, so always check your contract or local labor rules before treating an estimate as final.
Common Mistakes to Avoid
- Forgetting to subtract unpaid lunch or rest breaks.
- Entering 7 hours 30 minutes as 7.30 instead of 7.5.
- Mixing AM and PM times when calculating long shifts.
- Adding weekly totals before checking each daily shift.
- Using estimated overtime rules without confirming the rule that applies to your location.
The fastest way to avoid these mistakes is to calculate one shift at a time, keep break time separate, and convert minutes to decimals only at the end. That gives you clean numbers for timesheets, invoices, and payroll estimates.