Excel timesheet templates
Six free .xlsx timesheets with the formulas already in place. Type your times or hours, and the totals and the billable split fill in as you go.
Download a template
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 | | | | | | |
Weekly timesheet
Monday to Sunday with start and end times and breaks. The dates fill in from the week's start date.
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
A line per project and task, a column per day, and SUMIF for the billable hours.
Monthly timesheet
NameMonth
| Day | Start | End | Break | Hours | Notes |
| 1 | 9:00 | 17:30 | 30 | 8.00 | |
| 2 | 9:00 | 16:00 | 30 | 6.50 | |
| 3 | 8:30 | 12:30 | | 4.00 | Half day |
| 4 | | | | | |
| 5 | | | | | |
| 6 | | | | | |
Monthly timesheet
Days 1 to 31 with start and end times and breaks, and a header row that stays in view as you scroll.
Monthly timesheet
NameMonth
| Project | Task | Billable | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | | Total |
| Acme Health | Design | Yes | 3 | 2 | | 4 | 2.5 | | | | | | 11.50 |
| Northwind | Development | Yes | 4 | 5 | 6 | | 3 | | | | | | 18.00 |
| Internal | Admin | No | 1 | | 1 | | 0.5 | | | | | | 2.50 |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
Monthly timesheet with projects
A line per project and task and a column for each day of the month, with the project columns frozen on the left.
Daily timesheet
NameDate
| Start | End | Break | Hours | Notes |
| 9:00 | 12:30 | | 3.50 | Client workshop |
| 13:15 | 17:45 | 15 | 4.25 | Design review and changes |
| | | | |
| | | | |
| | | | |
| | | | |
Daily timesheet
One day's start and end times, breaks and notes, with the day's total.
Daily timesheet
NameDate
| Project | Task | Start | End | Hours | Billable | Notes |
| Acme Health | Design | 9:00 | 11:30 | 2.50 | Yes | |
| Acme Health | Client call | 11:30 | 12:15 | 0.75 | Yes | |
| Internal | Admin | 13:00 | 13:45 | 0.75 | No | Invoices |
| | | | | | |
| | | | | | |
| | | | | | |
Daily timesheet with projects
Each piece of work on its own line, with project, task, times and a billable column.
- Hours on a line.
=IF(COUNT(C7:D7)=2,MOD(D7-C7,1)*24-E7/60,"") waits until both times are filled in, takes the start from the end, turns the result into hours and subtracts the break, typed in minutes. MOD keeps a shift that runs past midnight positive.
- Totals.
=SUM(F7:F13) adds up a column. In the project grids, each line's total adds up its days in the same way.
- Billable hours.
=SUMIF(C7:C18,"Yes",K7:K18) adds up the lines marked Yes. Non-billable is the total minus that.
- Dates. In the simple weekly timesheet, each day's date is the week's start date plus a number of days, as in
=IF($B$4="","",$B$4+1).
Tips for using them in Excel
- Type times with a colon, like 9:00 or 17:30. A number on its own, like 9, is read as days, not hours.
- To add lines, insert rows between the first and the last line of the table. The totals grow with them.
- Use the Yes or No menu in the billable column. A line left empty counts as non-billable.
- Each file is set to print on one page, in portrait or in landscape. Check it in File, then Print.
- The cells you type in are unlocked. Review, then Protect Sheet, locks the formulas and keeps the rest editable.
- There are no macros, since the .xlsx format can't hold them.
Other spreadsheet apps
The files are standard .xlsx, so they also open in Excel on the web, Google Sheets, Apple Numbers and LibreOffice. For Google Sheets there is also a CSV version of each template, with the steps on the Google Sheets timesheet templates page. Every template is listed on the timesheet templates page.
Questions people ask
Is there an Excel timesheet template with formulas?
Yes, all six on this page. They work out each line's hours and the totals and, in the versions with projects, the billable and non-billable hours.
How do I calculate hours worked in Excel?
Subtract the start time from the end time and multiply by 24 to get hours, as in =(D7-C7)*24. Take off the break by subtracting its minutes divided by 60, and use MOD(D7-C7,1) instead of D7-C7 if a shift can run past midnight.
Can I protect the formulas?
Yes. The cells you type in are already unlocked, so Review, then Protect Sheet, locks only the formulas.
Do the templates contain macros?
No. They are .xlsx files, a format that can't hold macros.
Why does a cell show ####?
The column is too narrow for the number. Drag the right edge of the column header to widen it.