How to Calculate Hours Worked: Tracking Shift Duration, Breaks, and Overtime
A complete guide to calculating hours worked on a timesheet. Learn how to convert minutes to decimal hours, subtract unpaid breaks, and apply overtime thresholds.
Why Accurately Calculating Hours Matters
For hourly employees, freelancers, and payroll administrators, calculating hours worked correctly is crucial to ensuring accurate compensation and compliance with labor regulations. Errors in logging shift start and end times, misinterpreting break subtractions, or incorrect overtime calculations can lead to wage disputes, regulatory audits, or underpaid wages.
Timesheet calculations are uniquely complex because time is measured on a base-60 scale (sexagesimal), whereas payroll math is calculated using a standard base-10 decimal scale. This guide outlines the exact formulas and conversion steps to calculate paid hours, overtime hours, and gross pay.
Step 1: Converting Minutes to Decimal Hours
To compute wages, you cannot simply multiply hours and minutes by a wage rate. For example, working 8 hours and 30 minutes at a rate of $20/hour does not equal 8.30 × $20 ($166.00). It must be converted into decimal hours: 8.50 × $20 = $170.00.
Swipe sideways to compare columns.
| Minutes Worked | Fraction of 60 | Decimal Equivalent | Example (8 Hours + Mins) |
|---|---|---|---|
| 15 Minutes | 15 / 60 | 0.25 | 8.25 Hours |
| 30 Minutes | 30 / 60 | 0.50 | 8.50 Hours |
| 45 Minutes | 45 / 60 | 0.75 | 8.75 Hours |
| 10 Minutes | 10 / 60 | 0.17 | 8.17 Hours |
| 20 Minutes | 20 / 60 | 0.33 | 8.33 Hours |
| 40 Minutes | 40 / 60 | 0.67 | 8.67 Hours |
| 50 Minutes | 50 / 60 | 0.83 | 8.83 Hours |
Step 2: Subtracting Unpaid Lunch Breaks
Under standard labor regulations (such as the US Fair Labor Standards Act), short rest breaks (5 to 20 minutes) must be paid and counted as hours worked. However, bona fide meal periods (typically 30 minutes or longer) are unpaid, provided the employee is completely relieved from duty.
To subtract breaks, calculate the gross duration of the shift first, and then subtract the unpaid break minutes before converting to decimal hours.
Step 3: Calculating Overtime Hours
Overtime rules dictate how hours worked beyond a certain threshold are compensated. There are two primary types of overtime thresholds:
- Weekly Overtime: The FLSA standard mandates overtime pay (1.5x regular wage) for any hours worked beyond 40 in a single workweek.
- Daily Overtime: Certain jurisdictions (like California) require overtime pay for any hours worked beyond 8 in a single workday, and double-time (2.0x) for hours exceeding 12.
Swipe sideways to compare columns.
| Day | Start Time | End Time | Break (Mins) | Paid Hours | Regular Hours | Overtime Hours |
|---|---|---|---|---|---|---|
| Monday | 09:00 | 17:30 | 30 | 8.00 | 8.00 | 0.00 |
| Tuesday | 09:00 | 18:00 | 30 | 8.50 | 8.50 | 0.00 |
| Wednesday | 08:30 | 17:30 | 30 | 8.50 | 8.50 | 0.00 |
| Thursday | 09:00 | 17:30 | 30 | 8.00 | 8.00 | 0.00 |
| Friday | 09:00 | 18:30 | 30 | 9.00 | 9.00 | 0.00 |
| Saturday | 09:00 | 13:00 | 0 | 4.00 | 0.00 | 4.00 |
| Total | 46.00 | 40.00 | 6.00 |
Frequently Asked Questions
Do holidays or vacation count toward overtime thresholds?
Generally, no. Under federal FLSA standards, overtime is only calculated based on hours actually worked. If you take 8 hours of paid vacation, and then work 35 hours in the same week, your total paid hours is 43, but you will not receive overtime pay because actual hours worked was under 40.
How do you calculate overnight shifts?
For shifts crossing midnight, add 24 hours (1,440 minutes) to the end time before subtraction. For example, a shift from 10:00 PM (1,320 minutes) to 6:00 AM (360 minutes) yields: 360 + 1,440 - 1,320 = 480 minutes, which is exactly 8.0 hours.
Can I export my calculated timesheet to a spreadsheet?
Yes! Our Timesheet Hours Calculator supports dynamic weekly entries and lets you download a fully formatted CSV file of your logged hours with a single click, ready for Excel or Google Sheets.