Timesheet Calculator
Clock in, clock out, minus the break - for a whole week
Fill in the times you started and finished each day and the unpaid break you took. Each day shows the hours worked, and the week total appears in both hours and minutes (37:30) and decimal hours (37.50), because payroll systems ask for one and humans think in the other.
Clock in
Clock out
Break (min)
Days with hours (5 of 7)
5
Week total, decimal hours
37.50
Columns are clock in, clock out and unpaid break in minutes. An empty row is skipped.
How this timesheet calculator works
Every time you type is converted to minutes since midnight, which is what makes the arithmetic dependable. The clock-in is subtracted from the clock-out, the unpaid break comes off what is left, and each day is added to the week total in minutes. Only the last step converts back to hours, so nothing is rounded twice.
Worked minutes = (clock out - clock in) - unpaid break
Hours worked = worked minutes / 60
Week total = sum of every day's worked minutes
•
A clock-out earlier than the clock-in is read as a shift that crosses midnight, so night shifts add up correctly.
•
A break longer than the shift is reported as a problem instead of producing negative hours.
•
Rows you leave empty are skipped, so a four-day week needs no zeroes.
•
The decimal total is rounded to two places, so a third of an hour shows as 0.33.
Worked example
A Tuesday that started at 8:45, finished at 17:20 and included a 45 minute unpaid lunch:
Clock out 17:20 = 1040 minutes past midnight
Clock in 8:45 = 525 minutes past midnight
1040 - 525 = 515 minutes on the clock
515 - 45 minute break = 470 minutes worked
470 minutes = 7:50, or 7.83 decimal hours
Note how far apart 7:50 and 7.83 look. A timesheet that reports 7.50 for seven hours and fifty minutes underpays by twenty minutes, and it is one of the most common payroll mistakes there is. That is the whole reason this page shows both numbers side by side.
About payroll rounding
Many employers round each entry to the nearest quarter hour, so 8:52 becomes 9:00 and 17:07 becomes 17:00. This calculator does not do that for you, because rounding rules differ by employer and by country, and applying the wrong one is worse than applying none. If your employer rounds, round the clock times before you type them in and the totals will match the payslip.
Stop retyping your hours
A timesheet you fill in on Friday is a memory test. TickTappy records the time as it happens - one tap to start, one tap to stop - and the week is already added up. Free, no account needed.
FAQ
How do I calculate hours worked from clock-in and clock-out times?
Subtract the clock-in time from the clock-out time, then subtract any unpaid break. Doing it in minutes is the safe way: 8:45 to 17:20 is 515 minutes, less a 45 minute break, is 470 minutes, which is 7 hours 50 minutes or 7.83 decimal hours.
Does the calculator handle overnight shifts?
Yes. If the clock-out time is earlier than the clock-in time, the shift is treated as crossing midnight, so 22:00 to 06:00 counts as 8 hours rather than a negative number. A clock-out identical to the clock-in counts as zero, not 24 hours.
Should I enter paid breaks?
No. Only enter breaks that are unpaid and therefore come off the total. Leave the break field empty or type 0 for a paid break, and your coffee break stays in the paid total.
What time formats can I type?
24-hour times like 9:15 and 17:30, a bare hour like 9, and 12-hour times with am or pm like 5pm or 9:15 AM. Midnight at the end of a shift can be typed as 24:00 or 0:00 - both give the same result.
Is my timesheet saved anywhere?
No. The rows live in the page while it is open. Nothing is sent to a server, nothing is stored on your device, and reloading the page brings back the example week.
Related calculators