How to add and subtract hours and minutes
Time arithmetic trips people up because it counts in sixties. These methods make it simple, and they are the same steps the time calculator follows.
Open the tool: Time Calculator
Adding times: carry at 60
- Add the seconds; for every 60, carry 1 minute.
- Add the minutes plus the carry; for every 60, carry 1 hour.
- Add the hours plus the carry.
Subtracting times: borrow 60
If the minutes on top are smaller, take 1 hour from the hours and add 60 to the minutes. 5:10 − 2:40: borrow, so 4:70 − 2:40 = 2:30.
Excel and Google Sheets
Type times as 1:45 and add them with =SUM(A1:A10). Format the total cell as [h]:mm so it does not roll over to 0 after 24 hours. To get decimal hours, multiply a time by 24: =A1*24.