Free XLSX template
Free Timesheet Excel template
Record work sessions and total their hours. Download an original XLSX workbook or make it your own in the online editor.
Download original XLSXMake your workbook
| 1 | Date | Project | Start | Finish | Break Hours | Hours |
|---|---|---|---|---|---|---|
| 2 | 2026-10-11 | Example project | 09:00 | 17:00 | 0.5 | =IF(OR(C2="",D2=""),"",(D2-C2)*24-E2) |
| 3 | 2026-10-12 | =IF(OR(C3="",D3=""),"",(D3-C3)*24-E3) | ||||
| 4 | 2026-10-13 | =IF(OR(C4="",D4=""),"",(D4-C4)*24-E4) | ||||
| 5 | 2026-10-14 | =IF(OR(C5="",D5=""),"",(D5-C5)*24-E5) | ||||
| 6 | 2026-10-15 | =IF(OR(C6="",D6=""),"",(D6-C6)*24-E6) | ||||
| 7 | 2026-10-16 | =IF(OR(C7="",D7=""),"",(D7-C7)*24-E7) | ||||
| 8 | 2026-10-17 | =IF(OR(C8="",D8=""),"",(D8-C8)*24-E8) | ||||
| 9 | =IF(OR(C9="",D9=""),"",(D9-C9)*24-E9) | |||||
| 10 | =IF(OR(C10="",D10=""),"",(D10-C10)*24-E10) | |||||
| 11 | =IF(OR(C11="",D11=""),"",(D11-C11)*24-E11) | |||||
| 12 | =IF(OR(C12="",D12=""),"",(D12-C12)*24-E12) |
First 12 rows and 6 columns of Time. Formula cells show their expressions; generate the workbook to see calculated results.
What is in this workbook?
- Time: Date, Project, Start, Finish, Break Hours, Hours
- Totals
- Instructions
How to use the timesheet template
- Choose blank content or keep the fictional example, then set the dates and size you need.
- Generate the workbook and download it, or open it in the editor to enter your own details.
- Keep formula cells when replacing examples. Supported formulas update when you edit their inputs. Check any calculation diagnostics, then save your XLSX file.
Things to know
Same-day sessions only; negative or overnight intervals diagnosed. Overnight MOD support is outside this recipe; no payroll/legal guarantees.
Dates are stored in Excel’s 1900 date system. Currency options change display formatting only. Each workbook includes an Instructions sheet.
Browse all twelve templates