How to calculate hours worked from time punches
· payroll, time & attendance
To calculate hours worked from time punches, subtract the clock-in from the clock-out in minutes, subtract any unpaid break, and convert to hours last. A punch pair of 8:02 AM and 4:34 PM with a 31-minute unpaid lunch comes to 481 minutes, or 8.02 hours. The steps are simple. The mistakes come from doing them in a different order, from shifts that cross midnight, and from deciding which day a shift belongs to.
The method, in order
- Put both punches on a 24-hour clock. 4:34 PM is 16:34. This alone removes the most common slip, subtracting a PM time as if it were AM.
- Convert each time to minutes after midnight. 8:02 is 8 × 60 + 2 = 482. 16:34 is 16 × 60 + 34 = 994.
- Subtract. 994 − 482 = 512 minutes on the clock, or 8 hours 32 minutes.
- Subtract unpaid breaks, in minutes. Take out the actual meal break if it was punched, or the policy break if your policy deducts one automatically.
- Convert to hours once, at the end. Divide by 60. See minutes to decimal hours for payroll for the table and the rounding traps.
- Add the days of the workweek, in minutes, then convert the week.
A day with an unpaid lunch
An invented housekeeper at a 36-room motel outside a small town, placeholder wage $16 an hour. She punches in at 8:02 AM, out for lunch at 12:10 PM, back in at 12:41 PM, and out for the day at 4:34 PM.
With every punch recorded, the arithmetic is two blocks:
| Block | Start | End | Minutes |
|---|---|---|---|
| Morning | 8:02 | 12:10 | 248 |
| Afternoon | 12:41 | 16:34 | 233 |
| Worked | 481 |
481 ÷ 60 = 8.0167 hours, shown as 8.02. At $16 that is $128.27 for the day (8.0167 × 16 = 128.267). Notice that the lunch was 31 minutes, not 30. Counting actual punches pays her for what happened. A flat 30-minute deduction would have given 512 − 30 = 482 minutes, one minute more than she worked. One minute is nothing for a day and a matter of policy over a year; the longer discussion of when a flat deduction is appropriate is in automatic meal break deduction.
Whether a meal break is unpaid at all depends on your state’s rules and on whether the employee is relieved of duty during it, so check your own rule rather than copying ours. A break in which the employee must watch the desk is a different case from one spent in the parking lot.
A shift that crosses midnight
The subtraction above breaks for a night auditor. If he clocks in at 22:57 on Tuesday and out at 07:06 on Wednesday, 07:06 minus 22:57 is a negative number.
The fix is to add 24 hours (1,440 minutes) to the clock-out whenever it is earlier than the clock-in:
- Clock-in: 22 × 60 + 57 = 1,377 minutes.
- Clock-out, Wednesday: 7 × 60 + 6 = 426 minutes, plus 1,440 = 1,866.
- Elapsed: 1,866 − 1,377 = 489 minutes, which is 8 hours 9 minutes, or 8.15 hours.
You can check it a second way: 22:57 to midnight is 63 minutes, and midnight to 07:06 is 426 minutes. 63 + 426 = 489.
A time clock subtracts real timestamps, so this adding-24-hours step is only needed if you are working a paper sheet or a spreadsheet from clock faces. The trap on a spreadsheet is a formula that works on 360 shifts and quietly returns a negative number on the others.
Two more things belong with overnight shifts:
- Which day is it? Pick a convention and write it down. A common convention is to assign the whole shift to the day it started, so the Tuesday-night auditor’s 489 minutes are Tuesday’s. In a daily-overtime state, whether those minutes fall on Tuesday or Wednesday can change the premium. The longer version is in overtime on the wrong day and night audit overtime.
- Clock changes. Twice a year a night shift is an hour long or short in real elapsed time. Daylight saving and night shift hours covers what to pay when the arithmetic and the wall clock disagree.
A week, totaled
Here is the housekeeper’s week, in minutes, with the policy that unpaid lunch is whatever was punched:
| Day | Worked minutes | Hours |
|---|---|---|
| Mon | 481 | 8.02 |
| Tue | 478 | 7.97 |
| Wed | 0 | off |
| Thu | 492 | 8.20 |
| Fri | 475 | 7.92 |
| Sat | 466 | 7.77 |
| Week | 2,392 | 39.87 |
2,392 ÷ 60 = 39.8667, which displays as 39.87. Add the displayed days instead and you get 8.02 + 7.97 + 8.20 + 7.92 + 7.77 = 39.88, one hundredth different. That is the cost of adding rounded numbers, and it is why the week is added in minutes. She is 8 minutes under the 40-hour weekly overtime line (2,400 minutes), so a few extra minutes on one shift could tip her over. Use the overtime calculator if you want to test a week.
The punches that break the method
Everything above assumes every punch exists. In practice three things go wrong:
- A missing clock-out. There is nothing to subtract. Do not guess from the schedule; ask the employee, correct the punch with a note, and keep the original on record. Forgot to clock out walks through the correction.
- A missing lunch punch. If the policy is to deduct a set break, apply it. If the policy is to pay what was punched, the day looks 30 minutes longer than it was, and a manager should ask.
- A punch made early or late. The arithmetic faithfully counts time on the clock that was not working time. Clocking in early is worth a look if your totals run slightly above schedule.
Check yourself
Pick three shifts from last week and do them by hand with the six steps. Then compare with what your payroll shows. If all three match to the minute, your system is doing what you think it is. If one is off, the usual suspects are a flat break deduction, per-day rounding or an overnight shift assigned to the wrong day. A time clock that stores exact timestamps and shows the minutes makes this a thirty-second check; start a free trial if you want to see your own punches laid out that way.
Where this method stops: it computes time on the clock. Whether all of that time is payable, what counts as compensable travel or training time, and what your state requires for breaks are separate questions, and your state labor agency or payroll provider is the place to answer them.
Start seeing what labor actually costs
Set up your property, put staff on the clock, and read tomorrow morning’s labor number.
14-day free trial · No credit card · Cancel anytime