# 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.

**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.

**Step 3:** Hit the enter button to know the time difference.

**Formula 2**

**Step 1:** Enter the time** **in** **the order** **of Hour, Minute and Second as we have shown below for subtracting time.

**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.

**Step 3:** Hit enter to get the time difference.

**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.

**Step 2:** Hit enter to find the time difference between the two.

## Related Topics