Timesheet Total Hour Calculation Step By Step Example
Try Our Free Calculators
Want to crunch the numbers yourself? Use these free tools:
- Time Clock Calculator With Lunch Deduction 2026 — Time Clock Calculator With Lunch Deduction 2026
- Hour to Decimal Converter — Hour to Decimal Converter
- Work Hours Calculator — Work Hours Calculator
The Core Formula
Formula = Σ (Clock-Out − Clock-In) − Unpaid Breaks = Total Hours Worked
In English: for each day, subtract the start time from the end time, subtract any unpaid breaks, and add up the daily totals. Then convert minutes to decimals (15 minutes = 0.25 hours) so payroll can multiply by your rate.
Step-By-Step: A Full Week Worked Example
Let me walk you through a real week. Say you earn $20/hr and your timesheet looks like this:
| Day | In | Out | Lunch |
|---|---|---|---|
| Monday | 8:00 a.m. | 4:30 p.m. | 30 min |
| Tuesday | 8:00 a.m. | 5:00 p.m. | 30 min |
| Wednesday | 8:00 a.m. | 4:30 p.m. | 30 min |
| Thursday | 8:00 a.m. | 6:00 p.m. | 30 min |
| Friday | 8:00 a.m. | 4:30 p.m. | 30 min |
Now the math:
- Monday: 8:00 to 4:30 = 8.5 hours elapsed. Minus 0.5 lunch = 8.0 paid hours.
- Tuesday: 8:00 to 5:00 = 9.0 hours. Minus 0.5 = 8.5 paid hours.
- Wednesday: same as Monday = 8.0 paid hours.
- Thursday: 8:00 to 6:00 = 10.0 hours. Minus 0.5 = 9.5 paid hours.
- Friday: 8.0 paid hours.
Total: 8.0 + 8.5 + 8.0 + 9.5 + 8.0 = 42.0 paid hours.
Where do people mess this up? They forget Thursday pushed them over 40 — so 2 hours are overtime at 1.5×.
2026 Real Case: A Bookkeeper in Arizona
A friend runs the books for a small dental office. Her Thursday ran late because of a payroll emergency, and she didn’t realize she’d hit 42 hours. Her gross that week:
| Hours | Rate | Multiplier | Pay |
|---|---|---|---|
| First 40 hrs | $20 | 1.0× | $800.00 |
| Overtime (2 hrs) | $20 | 1.5× | $60.00 |
| Total gross | — | — | $860.00 |
If she hadn’t caught the OT, she’d have left $60 on the table. Over a year, that kind of miss adds up to real money. The time card calculator flags overtime automatically so you don’t have to scan every line.
Minute-to-Decimal Conversion
| Minutes | Decimal Hours |
|---|---|
| 0 | 0.00 |
| 15 | 0.25 |
| 30 | 0.50 |
| 45 | 0.75 |
| 50 | 0.83 |
So what does that mean for you? Always convert minutes to decimals before multiplying by your rate — 8 hours 45 minutes is 8.75 hours, not 8.45. The hour to decimal converter does this instantly. For weekly totals, the work hours calculator handles overtime thresholds in one pass.
For background reading, see our guide on how to use a time card calculator and our writeup on the best ways to track work hours.
Frequently Asked Questions
How do I convert minutes to decimal hours for payroll?
Divide the minutes by 60. For example, 45 minutes ÷ 60 = 0.75 hours, so 8 hours 45 minutes becomes 8.75 hours. Common conversions: 15 min = 0.25, 30 min = 0.50, 45 min = 0.75.
Do unpaid lunch breaks count as hours worked?
No. Unpaid meal breaks of 30 minutes or more where you’re completely relieved of duty are not counted as hours worked. They are subtracted from the elapsed time on your timesheet before calculating pay.
When does overtime kick in on a weekly timesheet?
Under the FLSA, overtime at 1.5× your regular rate applies to any hours worked over 40 in a single workweek. Some states like California also require daily overtime after 8 hours in a day, regardless of the weekly total.
Should I round my timesheet hours?
The FLSA allows rounding to the nearest 15 minutes as long as it averages out over time and doesn’t consistently favor the employer. Many employers track in 6-minute (0.1 hour) or 15-minute increments instead.
The Bottom Line
Timesheet math is just elapsed time minus unpaid breaks, with minutes converted to decimals and overtime applied after 40 hours. Run every week through the time card calculator before you submit so your hours — and your pay — are exactly right.