Free UK timesheet template pack. Weekly, fortnightly and monthly Excel timesheets with automatic total hours and overtime, plus a printable Word version.
Total hours on a timesheet = end time minus start time, minus unpaid breaks. This free pack contains weekly, fortnightly and monthly Excel timesheet templates that do that calculation automatically, split hours into standard and overtime, and total the week or month, plus a printable Word timesheet. It works in Excel and Google Sheets with no macros.
Free download
A free timesheet template pack for UK businesses: weekly, fortnightly and monthly Excel timesheets that work out total hours and overtime automatically, plus a printable weekly Word version for anyone who prefers pen and paper. Enter start, break and end times and the maths is done for you.
One zip with four files: weekly, fortnightly and monthly Excel timesheets (automatic hours, overtime and pay estimate) plus a printable weekly Word timesheet. Enter your details and the download starts immediately.
No newsletter spam. The form sends me your name, email and the exact resource requested so I can follow up properly.
Your request has been sent to me with the resource name, so I can follow up with the right notes.
Download timesheet pack (zip)Every Excel file has a README tab explaining the formulas and assumptions. Nothing is locked and there are no macros, so you can adapt the layout freely.
I spend most of my time helping UK businesses fix messy operational data, and timesheets are where a lot of that mess starts. Hours typed as text, breaks forgotten, overtime worked out differently every week. These templates force the arithmetic to be consistent so the numbers going into payroll are actually right. Rates last checked: 15 July 2026.
Take the end time minus the start time, then subtract unpaid breaks. For example 09:00 to 17:30 with a 30 minute break is 8.5 hours minus 0.5 hours, which is 8 hours. The Excel timesheets in this pack do that calculation for you.
You set a standard hours per day figure (the default is 8). Any hours above that on a given day go into the overtime column automatically. You can also set an hourly rate and an overtime multiplier to get an estimated gross pay figure.
They are the same layout with a different number of day rows: 7 for weekly, 14 for fortnightly and 31 for monthly. Pick whichever matches your payroll cycle. Each one has its own totals row and pay estimate.
Yes. The workbooks only use portable functions like IF, MIN, MAX, ROUND and SUM, so you can upload them to Google Drive and open them in Google Sheets without anything breaking. There are no macros.
Yes. Under the Working Time Regulations 1998 UK employers must keep adequate records to show they comply with the 48 hour average weekly working limit, and HMRC expects records that support minimum wage compliance. A completed timesheet is a simple way to cover both.
Yes. If the end time is earlier than the start time the spreadsheet assumes the shift ran past midnight and adds a day, so a 22:00 to 06:00 shift correctly shows 8 hours before breaks.
Drowning in spreadsheets?
Digital Adaption helps UK businesses fix the data behind the numbers: bookkeeping workflows, reporting you can trust and systems that talk to each other. Get in touch. Need a version of this tool built for your own company, with your rates, categories and workflows baked in? We build custom calculators, workbooks and internal tools. Contact us for a tailored quote.