Then, since 17 is smaller than 50, borrow 60 minutes (1 hour) by subtracting 1 hour from the hours answer. So, borrow 60 seconds (1 minute) from 21 minutes, which leaves you with 20 minutes. Alternatively, say the question is 5 hours 33 minutes 9 seconds - 1 hour 12 minutes 57 seconds.

The original number of minutes (11) is less than the 47 minutes being subtracted so: Subtract 1 from the original number of hours. For instance, if the problem reads “4 hours 37 minutes 55 seconds - 2 hours 6 minutes 45 seconds,” begin by subtracting 2 hours from 4 hours.

(11 minutes + 60 minutes = 71 minutes), Subtract the minutes. The next part is tricky since 9 seconds is smaller than 57 seconds.

First, subtract 1 hour from 5 hours, which equals 4 hours. References. Follow these steps: Add the hours; Add the minutes; If the minutes are 60 or more, subtract 60 from the minutes and add 1 to hours… So, 4 hours 37 minutes 55 seconds - 2 hours 6 minutes 45 seconds = 2 hours 31 minutes 10 seconds. In the Format Cells box, click Custom in the Category list. Up and Down keys to move from one row to the other. Sum or subtract times to get decimal hours/minutes/seconds with Kutools for Excel If you want to sum time and then get the results as decimal hours, minutes or seconds, you can use Kutools for Excel ’s Convert Time function. To learn how to use Excel to subtract time, keep reading! Example: 2m 30s plus 3m 45s minus 1m 45s equals 8 minutes. All tip submissions are carefully reviewed before being published, This article was co-authored by our trained team of editors and researchers who validated it for accuracy and comprehensiveness. So, 9 hours 17 minutes 22 seconds - 3 hours 50 minutes 1 second = 5 hours 27 minutes 21 seconds. Add or Subtract the hours and minutes separately. Next, subtract 50 from 77, which equals 27. Next, start by subtracting the hours since they’re the largest unit of time measurement. Kutools for Excel, with more than … Select add or subtract. Example: What is 4 hours 11 minutes minus 2 hours 47 minutes. Or, you can subtract time using Microsoft Excel by inputting a simple equation. By using our site, you agree to our. To subtract time by hand, first remember that 60 seconds is equal to 1 minute, and 60 minutes is equal to 1 hour. wikiHow is where trusted research and expert knowledge come together. (4 hours - 1 hour = 3 hours), Increase the number of minutes by 60. You can use this referral link to download Brave web browser. Once you finish with … To learn how to use Excel to subtract time, keep reading! This website will work offline on your device after the first visit. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

With arrow keys left and right you can navigate from one input to the other. Finish by subtracting the seconds (1 from 22, which equals 21). We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. Next, start by subtracting the hours since they’re the largest unit of time measurement. Increase the number of original minutes by 60. We use cookies to make wikiHow great.

Subtract the minutes. Convert 5 into 24 hour format and subtract 9.

Add 60 to 9, which is equal to 69. How to subtract hours and minutes. Since 4 - 2 = 2, the first part of the answer is 2 hours. With this tool you can add and/or subtract time units like hours, minutes and seconds as many times as you like. Include your email address to get a message when this question is answered. (71 minutes - 47 minutes = 24 minutes), Subtract the hours. For example, if the problem reads “4 hours 37 minutes 55 seconds minus 2 hours 6 minutes 45 seconds,” begin by subtracting 2 hours from 4 hours, which is 2 hours. Tool that adds and/or subtracts hours, minutes and seconds as many times as you like. In the above example, the problem is 55 seconds minus 45 seconds. Using the same example, the next step is to subtract 6 minutes from 37 minutes.

Brave is private, secure and fast. You can use + or - keys on your keyboard to add or subtract and Enter key to Show Result. Increase the number of original minutes by 60. Once you finish with the hours, subtract the minutes, so 6 minutes minus 37 minutes equals 31 minutes. This changes 6 hours to 5 hours in the example.