Weekly Timesheet Calculator
Log daily clock-in, clock-out, and breaks; auto-totals weekly hours, overtime, and gross pay.
Published by Blueprint Dynamics. Planning tools, not professional advice. Read the formula, assumptions, and examples below before relying on a result. Independent professional review is not claimed. Learn more about our methodology →
AllTemplates • Blueprint Dynamics • hello@bpdynamics.io. Educational worksheet; entries and assumptions are not independently verified. This document is not tax, legal, medical, investment or engineering approval. Review current official rules and seek a qualified specialist where appropriate.
Scope and reference context
Keep original invoices, receipts and approvals. A worksheet records your assumptions and entries; it does not verify delivery, collect payment, enforce a contract or synchronize inventory.
Primary reading context, not an endorsement or evidence that the linked organization reviewed this tool. No independent professional sign-off is claimed.
About the Weekly Timesheet Calculator
Payroll disputes almost always trace back to fuzzy time records: a break that was never subtracted, an overtime hour that got rounded away, or a Friday that nobody logged. A weekly timesheet fixes this by capturing clock-in, clock-out, and unpaid break for each day, then doing the hour math the same way every time. For hourly staff, this single sheet is the difference between a clean paycheck and a Monday-morning argument with the shift manager.
This calculator uses 24-hour decimal time, so 9 means 9:00 a.m. and 17.5 means 5:30 p.m. You enter a start, an end, and break minutes for each of the seven days, plus one hourly rate. It nets out the break, sums the week, splits the total into regular and overtime hours at the 40-hour line, and prices the result at your rate with time-and-a-half on overtime. Weekend rows default to zero so a standard Monday-to-Friday week works out of the box.
How the Weekly Timesheet Calculator works
Each day's hours equal end time minus start time, minus break minutes divided by 60, with any negative result floored at zero. So a 9 to 17 shift with a 30-minute break yields 8 minus 0.5, or 7.5 paid hours. The week total is the sum of all daily hours. Regular hours are capped at 40 using a minimum function, and overtime is whatever exceeds 40.
Gross pay stacks two rates: regular hours multiplied by your hourly rate, plus overtime hours multiplied by the rate times 1.5. This mirrors the federal FLSA rule that non-exempt employees earn one and a half times their regular rate beyond 40 hours in a workweek. The tool counts hours in decimal form, so if you track minutes, convert them first: 15 minutes is 0.25, 20 minutes is 0.33, and 45 minutes is 0.75.
Worked example
The default week runs Monday and Tuesday 9 to 17 with 30-minute breaks (7.5 hours each), Wednesday 9 to 17.5 with a 30-minute break (8.0 hours), Thursday 9 to 18 with a 30-minute break (8.5 hours), and Friday 9 to 17 with a 30-minute break (7.5 hours). Saturday and Sunday are zero. That sums to 39.0 hours for the week.
Because 39 hours is under the 40-hour threshold, all of it counts as regular and overtime stays at zero. At the default rate of $25 per hour, gross pay is 39 times $25, which equals $975. Add a 90-minute Saturday shift and the total would cross 40, pushing 0.5 hours into overtime at $37.50 an hour.
Tips & common mistakes
- Convert real minutes to decimals before entering them: 10 minutes is 0.17, 30 is 0.5, and 45 is 0.75, so a 5:45 p.m. clock-out is 17.75.
- Always fill the break field for shifts over six hours; forgetting a 30-minute lunch inflates the week by 2.5 hours across five days.
- The overtime line uses a strict 40-hour weekly threshold, not daily overtime; if your state mandates daily OT over 8 hours, that rule is not applied here.
- Keep the hourly rate as the base (straight-time) rate; the tool computes the 1.5 multiplier itself, so do not pre-multiply it.
- Delete unused weekend rows or leave them at zero start and end so they contribute nothing to the total.
Weekly Timesheet Calculator: frequently asked questions
How do I enter a shift that ends in the evening?
Use 24-hour decimal time. A shift ending at 5:30 p.m. is 17.5, 6:00 p.m. is 18, and 8:15 p.m. is 20.25. The start of 9:00 a.m. stays 9. The tool subtracts start from end, so both must be on the same numeric scale.
Why is my overtime showing zero when I worked long days?
Overtime here triggers only when the weekly total passes 40 hours. Four ten-hour days total 40 and stay entirely regular. Daily overtime rules, which some states apply after 8 hours in a day, are not calculated by this weekly tool.
How are breaks handled in the hour count?
Break minutes are treated as unpaid and subtracted from that day's span. A 9 to 17 shift is 8 clock hours; a 30-minute break makes it 7.5 paid hours. Enter breaks in minutes, not decimals.
What rate is used for overtime pay?
Overtime hours are paid at 1.5 times the hourly rate you enter. At a $25 base, overtime is $37.50 per hour. You enter only the straight-time rate; the tool applies the time-and-a-half multiplier automatically.
Can I add more than seven days?
Yes, the Add Day button appends rows, which is useful for a two-week pay period on one sheet. Remember the 40-hour overtime split still applies to the combined total, so for separate weeks keep them on separate timesheets.