How to Calculate Work Hours: Complete Guide to Daily & Weekly Shift Math
Learn the exact mathematical formulas to calculate daily work hours, deduct unpaid breaks, and tally weekly shift timesheets accurately.
Interactive Work Hours Calculator
Shift Clock In & Out Times
Calculate elapsed time and subtract unpaid breaks.
1. The Universal Shift Duration Formula
Calculating Elapsed Time Between Clock-In and Clock-Out
Calculating daily work hours begins by determining the total elapsed time between your start time and end time, then subtracting any designated unpaid break periods.
Mathematical Formula: Elapsed Minutes = End Time (in minutes from midnight) - Start Time (in minutes from midnight). If a break is unpaid under your workplace rules, subtract the unpaid break duration from the elapsed shift time: Net Worked Minutes = Elapsed Minutes - Unpaid Break Minutes.
To obtain decimal hours for wage calculations, divide the net worked minutes by 60: Decimal Hours = Net Worked Minutes / 60.
Step-by-Step Example: An employee starts at 08:30 and clocks out at 17:00 with a 45-minute unpaid lunch. First, convert times to minutes from 00:00: Start = (8 × 60) + 30 = 510 minutes. End = (17 × 60) + 0 = 1,020 minutes. Elapsed time = 1,020 - 510 = 510 minutes (8 hours 30 minutes). Subtracting the 45-minute break yields 465 net working minutes. Finally, 465 ÷ 60 = 7.75 decimal hours (7 hours 45 minutes).
2. Converting Minutes to Decimal Hours for Payroll
Why 15 Minutes Equals 0.25 Hours, Not 0.15 Hours
A frequent mistake in manual timesheet arithmetic is treating minutes as decimals. Because an hour contains 60 minutes rather than 100, minute values must be divided by 60.
Treating 30 minutes as 0.30 instead of 0.50 results in a substantial underpayment over a week or month.
| Clock Minutes | Fraction of Hour | Decimal Hours | Calculation Formula |
|---|---|---|---|
| 15 minutes | 15 / 60 | 0.25 hrs | 15 ÷ 60 = 0.25 |
| 30 minutes | 30 / 60 | 0.50 hrs | 30 ÷ 60 = 0.50 |
| 45 minutes | 45 / 60 | 0.75 hrs | 45 ÷ 60 = 0.75 |
| 60 minutes | 60 / 60 | 1.00 hr | 60 ÷ 60 = 1.00 |
3. Reconciling Weekly Overtime Thresholds
Separating Base Regular Hours from Overtime Hours
After calculating each workday’s net hours, sum all shifts across the weekly pay period to calculate total weekly hours.
Compare the weekly total against your applicable overtime threshold (commonly 40 hours per week):
Regular Hours = Minimum of Total Hours and Overtime Threshold.
Overtime Hours = Maximum of 0 and (Total Hours - Overtime Threshold).
Multiply regular hours by your base hourly wage, and overtime hours by your base wage times the overtime multiplier (e.g. 1.5x) to compute estimated gross earnings.
4. Common Timesheet Calculation Mistakes to Avoid
Key Traps in Manual Timesheet Reconciliation
Mistake 1: Rounding intermediate daily calculations too early. Always sum total minutes first and convert to decimal hours at the weekly total level to prevent compounding fractional rounding discrepancies.
Mistake 2: Deducting paid rest breaks. If short rest breaks (e.g. 10–15 minutes) are compensated under your workplace rules, do not subtract them from billable shift hours.
Mistake 3: Subtracting times directly across midnight without adding 24 hours (1,440 minutes), which produces negative hours.