What's in the Excel file
- Week 1 and Week 2 sheets with one row a day, including shifts that finish after midnight.
- A Settings sheet for the employee, the approver, the first day of your week and an overtime preset (US federal, California, custom or none).
- A Summary sheet with weekly and fortnightly totals and signature lines.
- Formulas only, using functions Excel, Google Sheets and LibreOffice all have. There are no macros.
How to use it in Excel
- Download the file. Use the download button on this page to save weekly-timesheet.xlsx.
- Open it in Excel. Open the file. If Excel opens it in Protected View, choose Enable Editing so the formulas can calculate.
- Fill in Settings. Type the employee, the approver and the first day of week 1, and choose an overtime preset or None.
- Enter each day. On the Week 1 sheet, type the start and finish time and any unpaid break in minutes. Leave days you did not work blank. Use Week 2 for a fortnight.
- Print the Summary. Check the totals on the Summary sheet, print it, and sign it for the approver.
The formulas inside
- Hours worked
-
=IF(OR(B5="",C5=""),0,MAX(0,MOD(C5-B5,1)*24-D5/60))MOD(finish − start, 1) is the time between the two, even when the shift ends after midnight. Times 24 turns it into hours, and the unpaid break (minutes ÷ 60) comes off.
- Double time
-
=IF(Settings!$B$15="",0,MAX(0,E5-Settings!$B$15))Hours in the day past the double-time limit: 12 with the California preset.
- Daily overtime
-
=IF(Settings!$B$14="",0,MAX(0,E5-Settings!$B$14-J5))Hours past the daily limit (8 with the California preset) that aren't already double time.
- Weekly overtime
-
=IF(Settings!$B$16="",0,MAX(0,H12-Settings!$B$16))Regular hours in the week past the weekly limit: 40 with both US presets. It counts regular hours only, so daily overtime isn't counted twice.
- Seven-day warning
-
=IF(B21=7,"Worked all 7 days…","")Flags a week with work on all seven days. The file doesn't work out any seventh-day overtime, so check the rules that apply to you.
Every formula uses functions that Excel, Google Sheets and LibreOffice all have. There are no macros or scripts.
What the Excel version doesn't do
- The yellow cells are yours to fill in and the grey cells calculate, so they are locked. Unprotect the sheet (Review > Unprotect Sheet) if you want to change a formula; there is no password.
- The overtime presets only split hours at the limits they list. They do not decide whether overtime applies to you.
- It does not work out pay, tax or award rates.
Questions
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive, or use File > Import in Google Sheets. It only uses functions both programs have. We do not offer a "make a copy" link, because that needs a Google account to host the sheet.
Will it run on an older version of Excel?
It is a standard .xlsx file with ordinary formulas, so any version that opens .xlsx files can use it. It has no macros or add-ins.
Can I add more weeks?
The file has two weeks. For a longer period, save a copy per fortnight, or use the free timesheet calculator, which handles periods up to 62 days.
Last reviewed 30 October 2026. Free to use and change in your own business. Please don't resell the files or publish them as your own. More free templates.