- Free tools
- Timesheet calculator
Timesheet calculator
Type the in time, out time and break for each day of the week. You get the week total, the regular hours and the hours above a threshold you set. Download the sheet as a CSV file or print it.
The threshold is yours. Estimate only. Check your policy and the current rules, or ask an adviser. This is not legal advice.
Your result
- Result
- Press "Work it out" to see it here.
These are your own figures. We show no market averages. The threshold is yours. Estimate only. Check your policy and the current rules, or ask an adviser. This is not legal advice.
Zentaro Pulse free tool: https://pulse.zentaro.cloud/tools/timesheet-calculator. Worked out in the browser. Estimate only.
The formula
Hours for a day = out - in - break. Week total = sum of the days. Regular hours = the smaller of the week total and the threshold. Hours above the threshold = the week total minus the threshold, or 0. Decimal hours = minutes / 60.
A worked example (made-up numbers)
- Monday to Friday, 09:00 to 18:00 with a 60 minute break: 8 hours a day, 40 hours.
- Saturday, 09:00 to 13:00 with no break: 4 hours. Week total 44 hours.
- Threshold 40 hours: 40 regular hours and 4 hours above the threshold.
What this does not cover
- The threshold is whatever you type. It is not a legal limit and the tool does not say which hours must be paid at a higher rate.
- It covers one week at a time. Run it again for each week.
- It does not work out pay. Use the overtime calculator for that.
Questions about this tool
How do I calculate a weekly timesheet?
For each day take the out time minus the in time minus the break. Add the days. The tool does this and shows the week total as decimal hours and as hours and minutes.
How are overtime hours worked out here?
Any hours in the week above the threshold you type are shown as hours above the threshold. You choose the threshold, and your policy decides how those hours are paid.
Can I save or print the timesheet?
Yes. Use Print for a clean page, or download the table as a CSV file that opens in Excel or Google Sheets. Nothing is stored on our side.
Want this done for you?
Zentaro Pulse is attendance and workforce management for any business. It is launching in 2027. This tool stays free either way.
Last updated: