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

Esc