How to Calculate a Weekly Timesheet by Hand (Without Losing Minutes)

Written by Rachel Kim, Payroll Operations Editor

Fact-checked against DOL regulations & payroll standards & primary sources · Last updated July 2026

Software calculates timesheets in milliseconds, but the person approving them still needs to know how the math works — because approval is where errors become paychecks. Here is the complete manual method, built around the two places human timesheet math actually breaks: subtracting clock times, and mixing minutes with decimals.

Key Takeaways

Work each day as: (end − start) − unpaid breaks, keeping everything in hours:minutes until the final step.
Convert to decimals only once, at the end: total minutes ÷ 60.
Weekly total over 40 hours splits into regular and overtime lines before multiplying by rates.
The most common manual error is treating 37 minutes as 0.37 hours.

The Four-Column Worksheet

Rule one of hand calculation: never subtract clock times in your head across the noon boundary. 8:45 to 17:15 is easiest as (17:15 − 12:00) + (12:00 − 8:45) = 5:15 + 3:15 = 8:30. Deduct the unpaid lunch in minutes (8:30 − 0:30 = 8:00), write the day’s total, and move on. Decimals wait until Friday.

Our Framework: The Four-Column Method. Columns: In, Out, Unpaid break, Day total (h:mm). Sum the week in hours-and-minutes first — say 42:25. Convert once: 42 + 25÷60 = 42.42 hours. Split against 40: 40.00 regular + 2.42 overtime. At $20/hour: 40 × $20 + 2.42 × $30 = $800.00 + $72.60 = $872.60. One conversion, one split, one multiplication per rate — three places to check instead of thirty-five.

Checking Someone Else’s Timesheet in 60 Seconds

Three fast probes catch most errors: (1) scan the decimal column for values whose fraction exceeds .59 or looks like a clock reading (7.45, 8.15 — suspicious); (2) recompute the single longest day, where math errors concentrate; (3) confirm the overtime split happened on the weekly total, not day by day (federal overtime is weekly; only a few states, notably California, add daily overtime).

Frequently Asked Questions

Should timesheets show clock times or durations?

Both: punches for the legal record, durations for the math. A timesheet with only durations cannot be audited against reality.

How do I handle a 42:25 total on a calculator?

Convert the minutes first (25 ÷ 60 = 0.42), then attach: 42.42. Typing “42.25” silently loses 10 minutes.

Round each day or the weekly total?

If you round at all, do it consistently and neutrally per punch (the regulated method) — never re-round the weekly total on top.

This article is educational and reflects federal FLSA rules and standard payroll conventions as of 2026, verified against Department of Labor regulations and guidance. State rules can differ. It is not legal or accounting advice.

Shifts That Cross Midnight

Overnight shifts are where the by-hand method earns its keep, because clock subtraction fails visibly: 6:15 minus 22:30 is a negative number, and people patch it with guesses. The reliable trick is to split at midnight, the same way we split at noon. A shift from 22:30 to 6:15 becomes (24:00 − 22:30) + 6:15 = 1:30 + 4:45 = 7:45, which converts — once, at the end — to 7.75 hours. Cross-check with total minutes: 465 ÷ 60 = 7.75. Both roads must meet.

Decide in writing which day’s line the shift lives on. For pay math the convention does not change the total, but it changes which workweek the hours fall into when a shift straddles the weekly boundary — and that can move an hour into or out of overtime. Most employers assign the whole shift to the day it starts; any fixed, documented rule works, provided it does not wander week to week.

What the Paper Trail Must Contain

Hand calculation implies hand records, and federal rules are specific about what survives. Under the Department of Labor’s recordkeeping regulation, 29 CFR Part 516, an employer must retain, among other items, the time of day and day of week the workweek begins, hours worked each day, total hours each workweek, the regular rate, straight-time and overtime earnings — with payroll records kept three years and the timesheets behind them two. A handwritten four-column worksheet satisfies this comfortably; a text message saying “worked about 43 this week” does not.

Our habit when reviewing manual sheets: initial the weekly total, not each day. The person who signs the conversion step is the person who checked it, and the one number that must be right is the week’s h:mm total before it becomes a decimal. Every downstream figure — regular hours, overtime hours, gross pay — is derived from it by arithmetic anyone can re-run.

What if the employee forgot to punch out?

Reconstruct the time from the best available evidence — schedule, security logs, the employee’s own statement — and record it as an estimate with a note. Paying nothing for a missing punch is not an option; the work happened, and the pay must follow the best reconstruction you can defend on paper.

About the author

This site's calculators and guides are produced and reviewed by our editorial team. We check every figure against primary sources (such as IRS, SSA and DOL publications) before publishing, and we state the date the figures were checked. We are not licensed financial, tax or legal advisers and we do not provide personal advice.

See our methodology and editorial standards.