Weekly timesheet template
Two free weekly timesheets. The simple one has start and end times for each day, and the other has a line per project with a column per day. Download them for Excel or Google Sheets, or print them on one page.
Weekly timesheet
NameWeek starting
| Day | Date | Start | End | Break | Hours | Notes |
| Monday | | 9:00 | 17:30 | 30 | 8.00 | |
| Tuesday | | 8:45 | 17:00 | 45 | 7.50 | |
| Wednesday | | 9:00 | 13:00 | | 4.00 | Half day |
| Thursday | | | | | | |
| Friday | | | | | | |
| Saturday | | | | | | |
Simple weekly timesheet
One line per day from Monday to Sunday, with the date, start and end times, breaks and notes. Each day's hours and the week's total are worked out for you.
Weekly timesheet
NameWeek starting
| Project | Task | Billable | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total |
| Acme Health | Design | Yes | 2.5 | 3 | | 4 | 1.5 | | | 11.00 |
| Northwind | Development | Yes | 4 | 3.5 | 6 | 2 | 4 | | | 19.50 |
| Internal | Admin | No | 1 | | 1 | | 0.5 | | | 2.50 |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
Weekly timesheet with projects
One line per project and task, a column for each day, a Yes or No billable column, and the week's billable and non-billable hours at the bottom.
How to fill in a weekly timesheet
- Write your name and the date the week starts. In the simple Excel file, the date of each day then fills in by itself.
- Enter your start and end times each day, and your breaks in minutes. The spreadsheet versions work out the hours.
- In the version with projects, add a line for each project and task, type the hours under each day (1.5 for an hour and a half), and mark the line billable or not.
- At the end of the week, check the total, sign the sheet and send it for approval.
When does the week start?
The templates run from Monday to Sunday, as in the ISO 8601 week. If your payroll or your client counts weeks from Sunday, rename the day headings. The totals stay the same.
Breaks and overtime
The simple template takes each day's break away from its hours, so a day from 9:00 to 17:30 with a 30-minute break counts as 8 hours. It doesn't work out overtime, because the rules depend on your country, sometimes your state, and your contract. Compare the week's total with your own limit, such as 40 hours, to see what counts as overtime.
Need a different period? There are also monthly timesheet templates, daily ones on the timesheet templates page, and notes on the formulas in Excel timesheet templates.
Questions people ask
What is a weekly timesheet?
A record of the hours someone worked in one week, usually day by day. A manager or client approves it, and payroll or invoicing then uses it.
How do I work out the total hours for the week?
Work out each day's hours, which is the end time minus the start time minus breaks, then add the seven days together. The Excel and Google Sheets versions do both for you.
Can I use a weekly timesheet for several projects?
Yes, with the version with projects. Each project and task gets its own line, and the totals show the week's billable and non-billable hours.
How do I enter half an hour?
In the project grid, type hours as decimals, such as 0.5 for half an hour, 0.25 for 15 minutes and 1.75 for an hour and three quarters. In the simple version, type start and end times instead.
Does the template work out overtime?
No. Overtime rules depend on where you work and on your contract, so the template only adds up the hours. Compare the weekly total with your own limit.