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.