Accurately calculating work hours is essential for employees, independent contractors, freelancers, and small business owners. Understanding how timesheet math works helps ensure paychecks are always correct and simplifies invoice generation.
1. Calculating Daily Shift Hours
To determine the hours worked in a single shift:
- Record Clock-In and Clock-Out Times: Use 24-hour time or clearly note AM and PM.
- Find Total Elapsed Time: Subtract the start time from the end time.
- Subtract Unpaid Breaks: Deduct any unpaid lunch or rest breaks from the total elapsed time.
Example:
- Clock-in: 08:30 AM
- Clock-out: 05:00 PM (17:00)
- Total elapsed time: 8 hours and 30 minutes
- Unpaid lunch: 30 minutes
- Net working time: 8 hours 00 minutes
2. Converting Minutes to Decimal Payroll Hours
Payroll software and spreadsheets calculate wages using decimal hours rather than hours and minutes. To convert minutes to decimals, divide the number of minutes by 60:
- 15 minutes = 15 ÷ 60 = 0.25 hours
- 30 minutes = 30 ÷ 60 = 0.50 hours
- 45 minutes = 45 ÷ 60 = 0.75 hours
For non-standard minutes, the same rule applies. For example, 7 hours and 20 minutes:
- 20 minutes ÷ 60 = 0.33
- Decimal Hours = 7.33 hours
3. Calculating Overtime Pay
In most standard labor practices, non-exempt employees earn overtime pay for all hours worked over 40 in a single workweek:
- Regular Hours: Capped at 40 hours per week (paid at standard base rate).
- Overtime Rate: Typically 1.5× your regular hourly rate (often called "time and a half").
Example Calculation:
- Weekly Total: 46 hours at $20.00/hour
- Regular Pay: 40 hours × 20.00 = 800.00
- Overtime Rate: 20.00 × 1.5 = 30.00/hour
- Overtime Pay: 6 hours × 30.00 = 180.00
- Total Gross Earnings: 800.00 + 180.00 = $980.00
4. The Fastest Way to Track Shifts
Instead of manual math and risking payroll errors, use our free Work Hours Calculator. It handles daily shifts, overnight hours, weekly timesheets, and overtime pay automatically!