Timesheet Calculator

Enter start and finish times for each day. The calculator subtracts breaks, handles night shifts and works out overtime and pay.

Loading tool…

How to use the Timesheet Calculator

  1. Enter the in and out time and the unpaid break minutes for each day you worked.
  2. Choose an overtime rule (per day or per week), the hourly rate and the overtime multiplier.
  3. Read the totals, then copy the table into Excel or download a CSV.

One week (Mon–Sun) at a time; each shift up to 24 hours.

Frequently asked questions

How are overnight shifts handled?

If the out time is earlier than the in time, for example 22:00 to 06:00, the shift is counted as running past midnight (8 hours).

What is decimal hours?

Hours written as a number for payroll: 7 hours 45 minutes is 7.75. Multiply decimal hours by the hourly rate to get pay.

How is overtime calculated?

With the daily rule, hours above the limit on each day are overtime (for example over 8 h). With the weekly rule, hours above the weekly limit (for example 48 h) are overtime. Overtime is paid at rate × multiplier.

Are my times saved?

Yes, in this browser, so you can fill the week day by day.