Timesheet Calculator Add up a week of hours from clock-in and clock-out times

Enter start and end times for each day, plus any unpaid break in minutes. Times can be 24-hour (17:30) or 12-hour (5:30 PM). Overnight shifts are handled automatically.

DayStartEndBreak (min)Hours

Tip: leave a day blank for days off. If end is earlier than start, it's treated as an overnight shift.

Total hours
0
this week
Gross pay
total hours × rate

Do this in Excel or Google Sheets

With start in B2, end in C2 and break minutes in D2:

ResultFormula
Daily hours=(C2-B2)*24-D2/60
Overnight-safe=MOD(C2-B2,1)*24-D2/60
Weekly pay=SUM(hours)*rate

Time maths trips up a lot of Excel users because times are stored as fractions of a day. My course clears that up for good.

Learn Excel with my course →

How the timesheet works

Each day's hours are the time from start to end, minus the unpaid break. When the end time is earlier than the start, the calculator assumes the shift ran past midnight and adds the extra hours, so a 10 PM to 6 AM shift correctly reads as eight hours. Add an hourly rate and the total hours are multiplied out into gross pay.

Frequently asked questions

What time formats can I use?

Both 24-hour (09:00, 17:30) and 12-hour with AM/PM (9:00 AM, 5:30 PM) work. Keep a colon between hours and minutes.

Is this gross or take-home pay?

Gross — total hours times your rate, before any tax or deductions.

Does it calculate overtime?

Not automatically. It gives total paid hours; apply your own overtime rules to hours beyond your threshold.