How to Subtract Time in Excel

How to subtract one time from another time in excel?

Formulas to Subtract Time

There are many ways to calculate time in excel. This tutorial will guide you on how to subtract time in excel using Subtract one time from the other method to calculate time. As the times are numbers, you can subtract it to find the time difference just as any other numerical values. You can easily calculate the difference between two number using the below mentioned formulas. There are three formulas to subtract time which are listed below.
Formula 1
Calculating the difference between two values in the cell.
=A1-B1
Formula 2
Find the time difference in hours, minute and seconds.
=TIME(HOUR(A1), MINUTE(A1), SECOND(A1)) - TIME(HOUR(B1), MINUTE(B1), SECOND(B1))
Formula 3
Calculating difference between the specified times.
=TIMEVALUE("7:40 PM") - TIMEVALUE("5:50 AM")


Here we performed each formula in an excel for your reference.
Formula 1
Calculating the difference between two values in the cell
=A1-B1 (difference between any two cells)
Example
Step 1:
Enter the time in two separate cells.
Time Difference Excel Step1
Step 2: Enter the formula, enter a equal to(=) symbol, then select the two cells for which you need to find the time difference and separate them with the Minus(-) symbol.
Time Difference Excel Step2
Step 3: Hit the enter button to know the time difference.
Time Difference Excel Step3
Formula 2
Step 1:
Enter the time in the order of Hour, Minute and Second as we have shown below for subtracting time.
Difference Between Specified Time Step1
Step 2: Use the formula mentioned below.
=TIME(HOUR(A1), MINUTE(A1), SECOND(A1)) - TIME(HOUR(B1), MINUTE(B1), SECOND(B1))
You can copy, paste the formula in your excel and select the cell in which you have entered the time. Here in the image, we have entered time in A2 and B2 cell.
Difference Between Specified Time Step2
Step 3: Hit enter to get the time difference.
Difference Between Specified Time Step3
Formula 3
You can use this time value formula to find the time difference.
=TIMEVALUE("Start Time") - TIMEVALUE("End Time")
Step 1:
Copy and paste the formula in your excel. Replace the value in the start time and end time.
Finding Time Difference Using Formula
Step 2: Hit enter to find the time difference between the two.
Finding Time Difference Using Formula Result


Related Topics