1. Free tools
  2. Timesheet calculator
Free tool

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 numbers

The boxes start with an example. Replace it with your own numbers.

You set this. It is not a legal limit.

Hours for one week
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

The sum runs in your browser. The numbers you type are not sent to us. A copied link holds only the numbers, times and choices in the boxes, never names.

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.

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)

  1. Monday to Friday, 09:00 to 18:00 with a 60 minute break: 8 hours a day, 40 hours.
  2. Saturday, 09:00 to 13:00 with no break: 4 hours. Week total 44 hours.
  3. 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.

Formula version 1.0. Last reviewed 20 November 2026. Free, with no sign-up. The threshold is yours. Estimate only. Check your policy and the current rules, or ask an adviser. This is not legal advice.

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: