There are two different formulas you can use to subtract minutes from a time in Excel:

**Formula 1: Use Mathematical Calculation**

=A2-(14*(1/1440))

This particular formula subtracts **14 minutes** from the time in cell **A2**.

Note that we must divide by the number of minutes in a day (1,440) because otherwise Excel will attempt to subtract 14 *days* instead of *minutes*.

**Formula 2: Use TIME Function**

=A2-TIME(0, 14, 0)

This particular formula also subtracts **14 minutes** from the time in cell **A2**.

Both formulas produce the same results and both formulas work with times *and* datetimes in Excel.

The following examples show how to use each formula in practice with the following column of time values:

**Example 1: Use Mathematical Calculation to Subtract Minutes from Time**

We can type the following formula into cell **B2** to subtract 14 minutes from the time in cell **A2**:

=A2-(14*(1/1440))

We can then click and drag this formula down to each remaining cell in column B:

The times in column B represent the times in column A with 14 minutes subtracted from them.

**Example 2: Use TIME Function to Subtract Minutes from Time**

We can type the following formula into cell **B2** to subtract 14 minutes from the time in cell **A2**:

=A2-TIME(0, 14, 0)

We can then click and drag this formula down to each remaining cell in column B:

The times in column B represent the times in column A with 14 minutes subtracted from them.

Note that the **TIME(Hour, Minute, Second)** function can be used to add or subtract a specific number of hours, minutes and seconds from a time.

By using **TIME(0, 14, 0)** we are able to subtract exactly 14 minutes from each time.

**Note**: You can find the complete documentation for the **TIME** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Add & Subtract Weeks to Date in Excel

How to Convert Date to Month and Year Format in Excel

How to Calculate the Difference Between Two Dates in Excel