What the spreadsheet does
- Hours per day from time in, lunch out, lunch in and time out. Leave lunch blank if you had no unpaid break.
- Overnight shifts work: a time out earlier than the time in counts as the next day.
- Weekly overtime after 40 hours (you can change the 40), paid at 1.5×.
- Regular pay, overtime pay and gross pay from your hourly rate.
- Dates fill in from the week starting date, and there are signature lines for you and your supervisor.
- The bi-weekly version counts overtime for each week separately, as the law requires.
How to use it in Google Sheets
- Download the .xlsx file.
- In Google Sheets choose File › Import › Upload and pick the file (or drag it into Google Drive and open it with Google Sheets).
- Type times like 8:00 AM or 17:30. The formulas work the same as in Excel.
The formula, if you build your own
With time in in C, lunch out in D, lunch in in E and time out in F, the hours for the day are:
=ROUND((MOD(F2-C2,1)-MOD(E2-D2,1))*24,2)MOD(…,1) handles shifts past midnight, and *24 turns Excel’s time into decimal hours. Weekly overtime is =MAX(0,total-40).
Spreadsheet or calculator?
The spreadsheet does weekly overtime only. If you have daily overtime (California, Alaska, Nevada, Colorado), double time, union rules, night premiums or Canadian provincial rules, the online calculator handles them and makes a PDF or CSV timesheet you can open in Excel. See also the guide to what a timesheet should include.
Questions
Is this timesheet template free?
Yes. Download the Excel or PDF files with no sign-up and no email. Use and share them as you like.
Does the Excel timesheet calculate overtime?
Yes. It adds up the week and pays hours over 40 at 1.5 times your rate. You can change the 40, for example to 44 for Ontario. The bi-weekly version counts each week on its own.
Does it work in Google Sheets?
Yes. Import the .xlsx file with File › Import in Google Sheets. All the formulas work.
How do I calculate hours in Excel?
Subtract the time in from the time out, subtract the lunch break, and multiply by 24 to get decimal hours: =(F2-C2-(E2-D2))*24. Wrap each subtraction in MOD(…,1) to handle overnight shifts.