Timesheet template

A timesheet is a record of the hours someone worked: the date, when they started and finished, the unpaid breaks they took and what the time was spent on. This free Excel template is a weekly timesheet that works out the hours on each line and the total for the week, with a filled-in example.

Download the Excel template

Excel (.xlsx) · 9 KB · free, no sign-up

Running a company of 30 to 200 people? Documents like this are now worth money.

Use it for hourly-paid staff, overtime claims, or charging time to clients and jobs. Kept and approved, the same sheets help show that working-time and pay rules are being met.

What's in the template

The workbook has a read-me, the blank weekly sheet and an example week. At the top of the sheet go the employee, the week commencing date, and who approved the week and when. Each line takes a date, a start and finish time, any unpaid break in minutes, and the job or project; Hours and the weekly total are formulas. The example week, for a fictional electrician:

DateStartFinishUnpaid break (minutes)HoursJob or projectNotes
05 Oct 202607:3016:00308.00Job 4471: house rewire 
06 Oct 202607:3012:0004.50Job 4471: house rewireFirst fix finished
06 Oct 202612:3016:3004.00Job 4480: office fault callIncludes driving between sites
07 Oct 202607:3015:30307.50Job 4480: office fault call 
08 Oct 202607:3016:00308.00Training: inspection and testing courseCourse day
09 Oct 202607:3014:00306.00Job 4492: consumer unit swapEarly finish agreed with manager
10 Oct 202609:0012:1503.25Call-out: emergency lighting faultSaturday overtime, authorised by the service manager
Total   41.25  

Hours are decimals (15 minutes is 0.25), which is what payroll and invoicing need: 41.25 hours times an hourly rate gives the right pay, where a time-formatted 41:15 wouldn't.

How to fill in the timesheet

  1. Use a fresh copy of the sheet each week (the read-me shows how), so approved weeks stay exactly as they were signed.
  2. Fill in the employee and the week commencing date at the top.
  3. Add a line for each stretch of work in 24-hour time, such as 7:30 to 16:15. When someone moves to a different job mid-day, start a new line, so each job gets its own hours.
  4. Put unpaid breaks in minutes on the line they fall in; the sheet deducts them. Breaks your contracts pay for stay inside the hours.
  5. Check the weekly total against contracted hours, and use the notes to say who authorised any extra time.
  6. Get it signed off by the manager, who adds their name and the date before it goes to payroll or invoicing.

Example: a field electrician's week

The example is a week for a fictional electrician at a 35-person electrical contractor. Tuesday has two lines because the job changed after lunch, and the lunch half hour between them isn't recorded. The afternoon line includes driving between sites: in the UK, travel that's part of the job counts as working time, as does Thursday's course. The Saturday call-out has its own line and a note of who authorised it, which payroll needs before paying overtime. The week comes to 41.25 hours.

UK and US rules a timesheet helps with

UK

  • In most jobs, workers can't work more than 48 hours a week on average, normally averaged over 17 weeks, unless they opt out. Under-18s can't work more than 8 hours a day or 40 hours a week.
  • Workers over 18 who work more than 6 hours a day have the right to one uninterrupted 20-minute rest break, which doesn't have to be paid (that depends on the contract), and to 11 hours' rest between working days.
  • Job-related training, travel that's part of the job and paid overtime count as working time. Lunch breaks with no work, holiday and the commute to a fixed workplace don't.
  • Employers must keep records proving they pay at least the minimum wage, typically pay and hours worked, and records created since 1 April 2021 must be kept for at least 6 years. Acas adds that you must keep records showing the 48-hour limit is being kept to (unless someone has opted out) for 2 years.

US

  • For employees covered by the federal minimum wage and overtime rules, employers must record the hours worked each workday and the total for each workweek.
  • Covered employees must be paid at least one and a half times their regular rate for hours over 40 in a workweek, and each workweek stands alone: hours can't be averaged across two weeks.
  • Time cards showing daily start and stop times must be kept for at least 2 years. Check your state's rules as well.

Check the linked pages before relying on these points; this page isn't legal advice.

Common mistakes

  • Filling it in from memory on a Friday. Times noted on the day are the ones that hold up if pay is ever questioned.
  • Rounding to the nearest hour, which quietly overpays some people and underpays others. The sheet works to the minute.
  • A night shift on one line. A finish after midnight is earlier than the start, so the hours come out negative. Split the shift at midnight.
  • Logging holiday as hours worked. It isn't working time; record it with a holiday request form so payroll treats it correctly.
  • Editing an approved week. Correct a mistake in the following week's sheet with a note, so the signed record stays intact.

Frequently asked questions

How do you calculate hours worked in Excel?

Subtract the start time from the finish time and multiply by 24, because Excel stores times as fractions of a day. Then take off unpaid breaks, converted from minutes to hours. The template's Hours column does exactly that and rounds to two decimal places.

How long should timesheets be kept?

In the UK, minimum wage records, which normally include hours worked, must be kept for at least 6 years. Under US federal rules, time cards must be kept for at least 2 years. Keep them longer if your own policies or contracts require it.

Sources