Why time math feels harder than it should
Ordinary numbers carry at 10. Minutes carry at 60. That one difference is behind almost every wrong time total, because our habits from regular addition kick in and we treat 1:50 like 1.50.
The fix is to keep hours and minutes in separate columns, or to turn everything into minutes before you start. Both methods work. Pick the one that feels natural and stick with it, because switching halfway through a list is how entries get counted twice or skipped. Write each entry the same way, with two digits for minutes, so 7 minutes is 0:07 and never 0:7.
Method 1: Add the columns, then carry
Add all the hours together, then all the minutes. For every 60 minutes, carry one hour over and keep the remainder.
Say you worked 2 hours 45 minutes, 3 hours 30 minutes and 1 hour 50 minutes. The hours add to 6 and the minutes to 125. 125 minutes is 2 hours 5 minutes, so the total is 8 hours 5 minutes.
- Hours: 2 + 3 + 1 = 6
- Minutes: 45 + 30 + 50 = 125
- Carry: 125 minutes = 2 hours 5 minutes
- Total: 8 hours 5 minutes
Method 2: Convert everything to minutes
Multiply each hour figure by 60 and add its minutes. Add the totals, then divide by 60 at the end. Whole number is hours, remainder is minutes.
The same three entries are 165, 210 and 110 minutes. That's 485 minutes. 485 divided by 60 is 8 with 5 left over, so 8 hours 5 minutes again. In decimal hours it's 8.08. This method is the easiest to do in a spreadsheet, too.
Formula notes
Total minutes = sum of (hours x 60 + minutes)Hours = whole part of total minutes / 60; minutes = remainder
Subtracting hours and minutes
Subtraction needs borrowing in the other direction. If the minutes on top are smaller, take one hour from the hours column and add 60 to the minutes.
8 hours 15 minutes minus 3 hours 50 minutes: 15 is less than 50, so borrow. That gives 7 hours 75 minutes. Now 7 - 3 = 4 and 75 - 50 = 25, so the answer is 4 hours 25 minutes.
Adding hours to a clock time
To find what time it will be after a duration, add the hours and minutes to the clock time and carry as usual. If the hour goes past 24, subtract 24 and you're into the next day.
A shift starting at 22:30 that lasts 7 hours 45 minutes ends at 29:75 before carrying. Carry 60 minutes to get 30:15, then subtract 24 to land on 06:15 the next morning. To check a span like this backwards, our hours calculator gives the time between the two clock times.
Slips to watch for
These are the errors that show up most when people add time by hand or in a spreadsheet.
- Writing 1 hour 30 minutes as 1.30 in a decimal column. It should be 1.5.
- Forgetting to carry when the minutes go past 59.
- Adding decimal hours and clock hours in the same list.
- Rounding each entry before adding instead of rounding the final total.
- Formatting a spreadsheet total as a clock time, which can wrap back to zero after 24 hours.
Frequently asked questions
What is 1 hour 45 minutes plus 2 hours 30 minutes?
4 hours 15 minutes. The hours add to 3 and the minutes to 75, and 75 minutes is 1 hour 15 minutes.
How do I add hours and minutes in Excel?
Enter durations as times like 2:45 and add them with SUM. Then give the total cell the custom format [h]:mm, which Microsoft recommends so totals above 24 hours don't wrap around.
How do I add decimal hours?
Add them like normal numbers. 2.75 + 3.5 + 1.25 is 7.5 hours. Just don't mix decimal hours with clock-style entries.
What is 0.1 hours in minutes?
6 minutes. Multiply any decimal hour by 60 to get minutes, so 0.4 hours is 24 minutes.
How many minutes are in 2.5 hours?
150 minutes. Multiply the hours by 60.
References
These sources support the method or guidance used for Hours Calculator. Verify time-sensitive rules at the source.
Try the calculator
Open Hours Calculator, enter your scenario, and compare its supporting rows with this guide's method and checks.