How to Add Hours and Minutes on a Timesheet

Adding a column of hours-and-minutes figures trips people up in a way that adding plain numbers never does, because minutes carry over at 60, not at 10. Add up a timesheet by hand without knowing this rule and the total is almost always wrong. Here's the fix.

The rule: carry at 60, not 10

Add all the hours together, then add all the minutes together separately. If the minutes total is 60 or more, subtract 60 from it and add 1 to the hours — exactly like carrying a digit in normal addition, except the "carry point" is 60 instead of 10.

Worked example: a five-day week

Five days worked: 7h 30m, 8h 15m, 6h 45m, 8h 00m, and 7h 50m.

1. Add the hours: 7 + 8 + 6 + 8 + 7 = 36
2. Add the minutes: 30 + 15 + 45 + 0 + 50 = 140
3. 140 minutes = 2 hours, 20 minutes remainder (140 ÷ 60 = 2 remainder 20)
4. Add that carried 2 hours to the 36: 36 + 2 = 38
5. Final total: 38 hours, 20 minutes

Try the same five values in the Timesheet Calculator or Weekly Time Calculator and confirm you get 38h 20m back.

A shortcut: convert to minutes first

If you're adding more than two or three entries, it's often easier to convert every entry to minutes, add those, and convert once at the end — that avoids doing the carry-at-60 step over and over.

• 7h 30m = 450 minutes
• 8h 15m = 495 minutes
• 6h 45m = 405 minutes
• 8h 00m = 480 minutes
• 7h 50m = 470 minutes
• Sum: 450 + 495 + 405 + 480 + 470 = 2,300 minutes
• 2,300 ÷ 60 = 38 remainder 20, so 38h 20m — the same answer

Worked example: a full seven-day week

The same method scales to a full week without changing at all. Seven days worked: 8h 00m, 7h 45m, 8h 30m, 7h 15m, 8h 00m, 4h 30m, and 0h (a day off).

1. Convert each to minutes: 480, 465, 510, 435, 480, 270, 0
2. Add them: 480 + 465 + 510 + 435 + 480 + 270 + 0 = 2,640 minutes
3. 2,640 ÷ 60 = 44 hours exactly, no remainder
4. Weekly total: 44h 00m

That total crosses the standard 40-hour overtime threshold by 4 hours — a good example of why an accurate weekly total matters, not just for record-keeping but for pay. See our guide on calculating total hours in a week for more on that step.

Adding across more than one week

For a bi-weekly pay period, add each week's total separately first, then add the two weekly totals together at the end — don't combine all 14 days into one long addition, since overtime is generally calculated per working week, not per pay period. Keeping the weekly totals visible also makes it easy to see which week (if either) actually crossed the overtime threshold.

Doing this in a spreadsheet

If you're adding hours and minutes in a spreadsheet rather than by hand, the safest approach is usually to enter times using the spreadsheet's own time format (so 7:30 means 7 hours 30 minutes, not 7 and a half) and let the software handle the 60-minute carry automatically through its SUM function. The moment you start treating a time value as a plain decimal or typing "7.30" to mean "seven-thirty," the carrying logic breaks, since spreadsheets and calculators alike will read that as 7 and 30 hundredths of an hour rather than 7 hours 30 minutes. When in doubt, convert to total minutes first (as shown above), do the plain-number addition there, and convert back to hours and minutes only once, at the very end.

Common mistakes

• Treating minutes like a decimal. "7h 30m + 0h 45m = 7h 75m" is correct as an intermediate step, but it has to be simplified to 8h 15m — it can't stay as "75 minutes" in a final total.
• Losing track of which column you're in. Keep a clear hours column and a clear minutes column, especially when adding by hand or in a spreadsheet without a proper time format.
• Forgetting to carry more than once. On a long timesheet, the minutes total can pass 60 more than once (as in the first example above, 140 minutes carries 2 full hours, not just 1).
• Merging two weeks into one addition for overtime purposes. Add each week separately when overtime is being tracked, even if you're also reporting a combined pay-period total.

Estimates only. Not legal, tax, or payroll advice.