Map Extract
Free tool

Weekly timesheet calculator

One row per day, Monday to Sunday. Enter start, finish and unpaid break, add an hourly rate if you want a pay figure, and the week totals itself, with overtime above the threshold you set.

Runs in your browser. Nothing you enter is uploaded.

Filling in the week

  1. Enter each day

    Type the start and finish for each day worked, such as 08:30 and 16:45, and the break in minutes. Leave days off empty; they show Not set and count as zero.

  2. Set the overtime rule

    Overtime after is the number of hours a week paid at the normal rate, such as 37.5. Overtime multiplier is the uplift for hours above that, such as 1.5 for time and a half.

  3. Add a rate for pay

    Put the hourly rate in pounds to see gross pay, or leave it empty for hours only.

  4. Copy it out

    Copy for a spreadsheet puts each day on its own row, tab separated, with the hours in decimal form, ready to paste into Excel or Google Sheets.

Example: a part-week of site visits and office time

An installer for a small signage company logs a week of surveys and fitting. Wednesday ran late at a shop fit-out and Friday was a short day. His contract pays £14.00 an hour for the first 37.5 hours and time and a half after that.

The week comes to 37 hours 45 minutes. That is 15 minutes over the threshold, so 37:30 is paid at the normal rate and 0:15 at £21.00 an hour, giving £530.25 before tax and deductions.

Input
Mon 08:30 to 16:45, break 30
Tue 08:30 to 17:15, break 30
Wed 09:00 to 18:30, break 45
Thu 08:30 to 16:00, break 30
Fri 08:00 to 14:00, break 0
Rate 14.00, overtime after 37.5, multiplier 1.5
Result
Total hours 37:45 (37.75)
Regular 37:30
Overtime 0:15
Gross pay £530.25

What the calculator does not decide for you

Overtime here is counted across the whole week, not day by day. If your contract pays extra for every hour beyond eight in a single day, or a different rate for Sundays, work those hours out separately. A finish earlier than the start counts as the next day, so night shifts need no extra setting, and gross pay is before tax and other deductions.

There is no legal overtime rate in the UK: whether extra hours are paid, and at what multiplier, is down to the contract. What the law does set is that average pay across all hours worked must not fall below the National Minimum Wage, and there are rules on rest breaks and weekly limits. GOV.UK's pages on overtime and working hours explain both.

Questions people ask

How do I calculate total hours on a timesheet?

For each day, take the start from the finish and subtract the unpaid break, then add the days together. Working in decimal hours makes pay easy: 37 hours 45 minutes is 37.75 hours. The calculator shows both forms side by side for each day and for the week.

How is overtime worked out?

Every minute above the weekly threshold is overtime, paid at the hourly rate times the multiplier. With a threshold of 37.5 and a 40 hour week, 2.5 hours are overtime. Set a very high threshold if you have no overtime.

Can I use it to track my own freelance hours?

Yes. Leave the rate empty, or enter your day rate divided into an hourly figure, and use the decimal total on your invoice. The spreadsheet copy gives you a simple weekly record to keep with your accounts, since the page itself does not save anything.

Where your data goes

Hours, rates and pay are calculated on your own device. The timesheet is not saved, so copy it out before you close the page.

Checked against the tool on

Top