Tools / Time and payroll

Weekly timesheet calculator

Fill in the days worked. Leave a day empty to skip it.

DayStartEndBreak (min)Hours
Mon8:00
Tue8:00
Wed8:00
Thu8:30
Fri6:30
Sat
Sun
Total hours
39:00
Decimal hours
39.00
Regular
39.00
Overtime
0.00

Do it in a spreadsheet

=SUMPRODUCT(MOD(B2:B8-A2:A8,1)*24-C2:C8/60)
  • A2:A8 start times, Monday to Sunday
  • B2:B8 end times
  • C2:C8 break 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.

More time and payroll tools

Free, from Producfy

Get the next guide before you need it

One email when a new guide or tool goes up: working formulas, queries and scripts for spreadsheets, SQL and the CRM and billing exports that end up in them. At most one a week.

Esc