Excel templates / Weekly timesheet

Weekly timesheet template with overtime

Start and end times and breaks give hours worked each day, then regular and overtime hours and the week’s pay.

Download the weekly timesheet template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Enter the name, the Monday the week starts, the hourly rate and your overtime rules in B3 to B7.
  2. Type each day’s start and end times like 9:00 and 17:30, and the unpaid break in minutes. Leave days off empty.
  3. A shift that ends after midnight (start 22:00, end 6:00) counts correctly. Hours, overtime and pay fill in below.

How it works

Learn the skills behind it

Functions used: TEXT, IF, OR, ROUND, SUM, MIN, MAX.

More free templates