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
- Enter the name, the Monday the week starts, the hourly rate and your overtime rules in
B3toB7. - Type each day’s start and end times like
9:00and17:30, and the unpaid break in minutes. Leave days off empty. - A shift that ends after midnight (start
22:00, end6:00) counts correctly. Hours, overtime and pay fill in below.
How it works
A10:A16=TEXT(B10,"dddd"): The day’s name from its date. The format code dddd spells it out in full.F10:F16=IF(OR(C10="",D10=""),0,ROUND((D10-C10+(D10<C10))*24-E10/60,2)): Hours worked. Excel stores times as fractions of a day, so end − start, × 24, gives hours. (D10<C10) adds one day when a shift ends after midnight, and the break comes off in hours (minutes ÷ 60).F19=MIN(F18,B6): Regular hours: all the hours, up to the overtime threshold.F20=MAX(0,F18-B6): Overtime: hours past the threshold, and never below zero.F22=F20*B5*B7: Overtime pay: overtime hours × the hourly rate × the overtime multiplier (1.5 for time and a half).
Learn the skills behind it
- How Excel stores times
- Timesheets and hours worked
- Pay and overtime
- Formatting numbers in text with TEXT
Functions used: TEXT, IF, OR, ROUND, SUM, MIN, MAX.