Timesheet Calculator
Add a row per shift with clock-in, clock-out and unpaid break to get paid hours, overtime and estimated gross pay. Overnight shifts included.
Rows are counted in the order they are listed, so put your shifts in the order they happened. The hours that cross the threshold are the ones in the later rows. While every row is paid at the same rate, changing the row order cannot change your total hours or total pay — though which row the overtime hours land in may change.
The threshold and multiplier above are editable examples, not legal rules. Overtime entitlements differ by country, state, industry and contract, and some places have none at all. Set them to whatever your own agreement says.
Shifts
| Day or date | Clock in | Clock out | Unpaid break (min) | Rate (optional) | Paid | Remove |
|---|---|---|---|---|---|---|
| — | ||||||
| — | ||||||
| — | ||||||
| — | ||||||
| — |
Add a clock-in and a clock-out to see the hours
Fill in a row above, or load the sample week to see how overnight shifts and overtime are handled.
Everything is calculated in your browser. Nothing you type is uploaded or saved.
Try another tool
Picked to go with this oneA timesheet calculator that works the way a week of shifts actually works: a row per day with a clock-in, a clock-out and an unpaid break, totalled into paid hours and, if you enter a rate, estimated gross pay. Shifts that run past midnight are counted as the hours they are rather than as a negative span, each row can carry its own rate, and you decide where overtime starts because no two places agree on that. Copy the summary, download it as a CSV, or print it.
How to use this tool
- 01Set your rate and overtime ruleEnter the hourly rate that applies to most shifts, then choose whether overtime starts after a weekly total, after a daily total, or not at all. The threshold and multiplier are yours to set.
- 02Add a row per shiftFill in the day, the clock-in and clock-out times, and how many minutes of unpaid break to subtract. Add as many rows as the period needs.
- 03Override a rate where it differsLeave the rate column blank to use the default. Fill it in on a row that was paid differently — a weekend rate, a different client, a higher-skilled job.
- 04Read the totals and exportPaid hours, regular hours, overtime hours and estimated gross pay appear underneath. Copy the summary, download a CSV for a spreadsheet, or print the page.
When is this useful?
- Submitting a weekly timesheetTotal a five- or six-day week with breaks subtracted, and hand in a figure you can show the working for.
- Checking a payslipWork out what the hours you actually recorded should come to, then compare that against what you were paid.
- Billing a client by the hourLog each session, put a different rate on the rows that were priced differently, and read off the total to invoice.
- Night and rotating shiftsA 22:00 to 06:00 shift counts as eight hours, so a week of nights totals correctly without any manual adjustment.
Examples
- A standard week with breaksFive days of 09:00 to 17:30 with a 30-minute unpaid break each day comes to 40 paid hours — 8:00 a day, not 8:30.
- A week that tips into overtimeFive 9-hour days against a 40-hour weekly threshold gives 40 regular hours and 5 overtime hours, with the multiplier applied only to those 5.
- A night shift22:00 to 06:00 with a 30-minute break is 7:30 paid. The row is marked as overnight so it is clear why the clock-out looks earlier than the clock-in.
Tips for a better result
- Enter breaks in minutes, not as a timeThe break column subtracts a duration. A 45-minute lunch is 45, not 00:45, and it comes off that row only.
- Daily and weekly overtime are different questionsDaily measures each shift on its own, so one long day creates overtime even in a short week. Weekly looks at the total, so a long day can be offset by a short one. Pick the one your agreement actually uses.
- Pay is estimated, and it is grossThe figure is hours multiplied by rate before any tax, deductions or contributions. It is a check on the hours, not a payslip.
- A row that looks wrong is told to youA break longer than the shift, a missing clock-out or a clock-in equal to the clock-out is flagged on the row and left out of the totals rather than quietly counted as zero.
How overnight shifts are counted
When the clock-out is earlier than the clock-in, the shift is read as finishing the next day. So 22:00 to 06:00 is eight hours, not minus sixteen. The one case the calculator will not guess at is a clock-in and clock-out that are identical: 22:00 to 22:00 is either a zero-length row or a full 24-hour shift, and picking one silently would be wrong half the time, so the row is flagged for you to correct.
Why there is no built-in overtime law
Overtime rules differ by country, by state or province, by industry and by individual contract, and in a good part of the world there is no statutory overtime premium at all. A calculator that assumed one rule would be quietly wrong for most of the people using it. So the threshold and the multiplier are inputs with editable example values. The common 40-hour, time-and-a-half convention is offered as a starting point because it is widely recognised, not because it is the law where you are.
How pay is rounded
Durations are held as whole minutes from start to finish, and hours are produced only for display. Pay is calculated by adding up the minutes at each rate first and pricing them once, rather than pricing each row and adding the results. That matters more than it sounds: three twenty-minute rows at 10 an hour are exactly one hour of work and are owed 10.00, but rounding each row first pays 3.33 three times and quietly loses a cent.
Frequently asked questions
Does it handle shifts that cross midnight?
Yes. If the clock-out is earlier than the clock-in, the shift is treated as ending the next day, so 22:00 to 06:00 counts as eight hours. Those rows are labelled "overnight" in the results so the totals are easy to check.
How is overtime decided?
By you. Choose overtime after a weekly total, after a daily total, or no overtime at all, then set the threshold and the multiplier. The 40 hours and 1.5× shown by default are editable examples, not a legal rule — entitlements vary by country, state, industry and contract.
Does the order of the rows matter?
With weekly overtime, yes: rows are counted from the top down, so the hours that cross the threshold are the ones in the later rows. List your shifts in the order they happened. This only changes the money when rows are paid at different rates, because order decides which rate the overtime hours are priced at — if every row shares a rate, changing the order cannot change your total hours or total pay, though the overtime hours may show against a different row. The day column is free text and is never sorted for you, since guessing what "Shift A" or "14/09" means and silently rearranging your timesheet would be worse than leaving it alone. Daily overtime is order-independent either way.
Can different days have different hourly rates?
Yes. Each row has an optional rate column that overrides the default for that row only. When weekly overtime is in play, the multiplier applies to the rate of the row the overtime hours actually fell in, not to a blended average.
Is the pay figure my take-home pay?
No. It is estimated gross pay: hours multiplied by rate, before income tax, social contributions, pension deductions or anything else. Treat it as a way to check the hours, not as a payslip.
What happens if I enter a break longer than the shift?
The row is flagged and left out of the totals rather than counted as zero hours. The same goes for a negative break, a missing clock-in or clock-out, and a time that cannot be read. Valid rows are still totalled normally.
Can I export the timesheet?
You can copy a plain-text summary, download a CSV with a row per shift and the totals underneath, or print the results. There is no account and nothing is stored.
Is anything uploaded?
No. The calculation runs entirely in your browser. Your hours, rates and day labels never leave your device, and nothing is saved between visits.