Tools / Time and payroll
Weekly timesheet calculator
Fill in the days worked. Leave a day empty to skip it.
- Total hours
- 39:00
- Decimal hours
- 39.00
- Regular
- 39.00
- Overtime
- 0.00
Do it in a spreadsheet
A2:A8start times, Monday to SundayB2:B8end timesC2:C8break minutes
How it works
Each day is MOD(end - start, 1) * 24 minus the break in hours, and SUMPRODUCT adds the week in one cell. Overtime is =MAX(0, total - 40) and regular hours are =MIN(total, 40). Overtime rules differ by country and contract, so check yours before paying from this.