HR template
Weekly timesheet
Record time in, lunch and time out for each day of the week. Hours over 40 become overtime and pay is calculated at your rates.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Timesheet
45 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 102 filled cells in all.
Built in
- Conditional formatting
- Named ranges
- 2 conditional format rules
A look at the Timesheet sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Weekly timesheet | |||||||
| 2 | Enter times in the yellow cells (like 8:00 AM). Leave a day blank if not worked. | |||||||
| 3 | Employee | Casey Morgan | Manager | Avery Lin | ||||
| 4 | Week starting | Nov 9, 2026 | Department | Fulfillment | ||||
| 5 | Hourly rate | $32.00 | ||||||
| 6 | Overtime rate | 1.5x | ||||||
| 7 | ||||||||
| 8 | Day | Date | Time in | Lunch out | Lunch in | Time out | Hours | Regular |
| 9 | Monday | Nov 9 | 8:00 AM | 12:00 PM | 12:30 PM | 5:30 PM | 9.00 | 9.00 |
| 10 | Tuesday | Nov 10 | 8:00 AM | 12:00 PM | 12:30 PM | 5:30 PM | 9.00 | 9.00 |
| 11 | Wednesday | Nov 11 | 7:45 AM | 12:00 PM | 12:30 PM | 6:00 PM | 9.75 | 9.75 |
| 12 | Thursday | Nov 12 | 8:00 AM | 12:00 PM | 12:30 PM | 5:30 PM | 9.00 | 9.00 |
- timesheet
- hours
- overtime
- payroll
- time tracking
More hr templates
HRPayroll registerCalculate gross pay, withholdings, deductions and net pay for each person on a pay run. Rates live in one box so a change updates every row.
HREmployee shift schedulePlan a week of shifts with a dropdown in every cell. Hours per person and coverage per shift add up as you fill the grid.
HREmployee directoryKeep contact details, teams, managers and start dates in one tidy list. Look anyone up by name and see headcount by department.
HRVacation and PTO trackerAccrue paid time off by month, log requests, and see each balance at a glance. Request days count working days only and skip holidays.
Start your weekly timesheet now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.