Free template

Timesheet template

A free weekly timesheet for UK employers, in Excel and PDF. The Excel version works out daily hours, unpaid breaks, overtime and gross pay for you, including night shifts that finish the next morning. The PDF is ready to print and fill in by hand.

Download the timesheet

One week per sheet, no sign-up. Save a copy for each week, or print a stack of the PDF for staff to fill in.

Free to use and adapt within your organisation.

What the timesheet includes

  • Employee detailsName, employee number, role or department, manager and the week commencing date. The date for each day fills in automatically.
  • Daily hoursStart, finish and unpaid break for each day, with the hours worked calculated to two decimal places. A finish earlier than the start is treated as an overnight shift.
  • Overtime and payOptional. Enter the weekly hours after which overtime starts, an hourly rate and an overtime rate, and it splits basic and overtime hours and shows gross pay.
  • NotesA column for holiday, sickness or anything else that explains a short or missing day.
  • Sign-offA line for the employee to confirm the hours, and for the manager to approve them.

How to fill it in

  1. Enter the week commencing date

    Use the Monday the week starts on. The dates for the rest of the week fill in by themselves.

  2. Use the 24 hour clock

    Type times as 09:00 and 17:30. For a night shift from 22:00 to 06:00, enter it as it happened and the sheet counts it as eight hours, not a negative number.

  3. Only enter unpaid breaks

    Paid breaks count as working time, so leave them in the hours. Enter unpaid breaks in minutes, for example 30.

  4. Check and sign

    The employee signs to confirm the hours are right, and the manager signs to approve them before they go to payroll.

  5. Keep it

    Store each week's sheet somewhere you can find it again. Records that show you paid at least the minimum wage have to be kept for years, not months.

Minutes to decimal hours

Timesheets and payroll usually work in decimal hours, which is where most mistakes creep in. Half an hour is 0.5, not 0.3. The Excel version does this for you; if you are filling in the PDF by hand, this is the conversion.

MinutesDecimal hoursExample
150.257 hours 15 minutes is 7.25
200.337 hours 20 minutes is 7.33
300.507 hours 30 minutes is 7.50
400.677 hours 40 minutes is 7.67
450.757 hours 45 minutes is 7.75

To check a single week quickly, the free hours worked calculator does the same sums in your browser.

What records you need to keep

There is no law that says you must use timesheets, but you do have to keep records that show you paid at least the National Minimum Wage, and those records have to be kept for six years. You also need records showing you kept to the working time limits, such as the 48 hour average week, for two years. Timesheets are one of the simplest ways to have both.

The rules and rates change, so check the current position on gov.uk: National Minimum Wage for employers and maximum weekly working hours.

This page is general guidance, not legal advice.

Frequently asked questions

How do I calculate hours worked on a timesheet?

Take the finish time away from the start time, then take off any unpaid break. For example, 09:00 to 17:30 is 8 hours 30 minutes, and with a 30 minute unpaid lunch that is 8 hours. The Excel timesheet does this for every day and adds up the week.

How do I write 7 hours 30 minutes on a timesheet?

As 7.50 in decimal hours, or 7:30 if your payroll uses hours and minutes. The common mistake is writing 7.30, which payroll will read as 7 hours 18 minutes.

Does the timesheet work for night shifts?

Yes. If the finish time is earlier than the start time, the Excel version treats it as a shift that ran past midnight, so 22:00 to 06:00 counts as eight hours before any break.

Should breaks be included in hours worked?

Paid breaks should, because they are working time. Unpaid breaks should not. Workers are generally entitled to a 20 minute rest break if they work more than six hours a day, and it is up to the contract whether that break is paid.

Do employers have to keep timesheets?

Not timesheets as such, but you must keep records that prove you paid at least the minimum wage, for six years, and records that show you met the working time limits, for two years. For hourly paid staff, timesheets or clocking records are usually how employers do that.

Can I use it for a monthly timesheet?

The template is weekly, because that is how most hourly paid staff are checked. For a month, save a copy for each week and add the weekly totals together, or copy the sheet four or five times in the same workbook.

How does the overtime calculation work?

Enter the number of hours a week after which overtime starts, and any hours above that are counted as overtime. There is no legal overtime rate in the UK, so the rate you enter should be whatever the employee's contract says. Leave the overtime box blank if you do not pay overtime.

Is the gross pay figure what the employee takes home?

No. Gross pay is before tax, National Insurance, pension contributions and any other deductions. It is there as a check before the hours go to payroll, not as a payslip.

Will the template work in Google Sheets or LibreOffice?

It uses standard formulas, so it opens and calculates in LibreOffice, and should work the same way if you upload it to Google Sheets.

Can I add my company logo or change the columns?

Yes. The Excel file is not locked, so you can add a logo, rename columns or add your own. If you change the start, finish or break columns, check the hours formula still points at the right cells.

When is it time to stop using paper timesheets?

Usually when checking them takes longer than the work they record, or when you find you are paying for hours nobody can confirm. A paper or spreadsheet timesheet relies on people writing down the right times; a clocking system records them as they happen. For a handful of staff on regular hours, a good timesheet is often enough.

Stop typing up timesheets

Syncro Connect records start and finish times from a clocking terminal, the app or the web, works out the hours and breaks, and exports them for payroll. From £2 per employee per month, excluding VAT, with a free trial and no card needed.

Left Menu Icon