Timesheet & Overtime Calculator Spreadsheet – Shift Hours, Weekly Totals, Overtime and Pay Estimate (Excel + Google Sheets)
Log shifts, see your week.
What's inside:
Settings: hourly rate, weekly overtime threshold, overtime multiplier and first week
Timesheet: up to 200 shifts with automatic hours and week start
Dashboard: 26 weeks of hours, regular hours, overtime hours and estimated pay
What you get:
Timesheet-and-Overtime-Calculator-Spreadsheet.xlsx – the blank timesheet
Timesheet-and-Overtime-Calculator-Spreadsheet-EXAMPLE.xlsx – filled with sample shifts
The calculations were checked against an independent model.
An estimate only. It does not calculate tax, National Insurance, holiday pay or minimum wage. Check your contract and payslip. Not payroll or legal advice.
Instructions are on the Start Here tab.
Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.
This is a digital download. No physical item will be shipped. For personal use only.