Filling in the week
Enter each day
Type the start and finish for each day worked, such as
08:30and16:45, and the break in minutes. Leave days off empty; they show Not set and count as zero.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.
Add a rate for pay
Put the hourly rate in pounds to see gross pay, or leave it empty for hours only.
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.
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
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