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
