Excel Formula to Subtract Minutes From a Time

Updated 9 November 2026 · Standard formula, shown below

To subtract minutes from a time in Excel, subtract the minutes divided by 1,440: if A1 contains the starting time and B1 contains the number of minutes, use =A1-B1/1440. Excel stores time as a fraction of a day, so dividing minutes by 1,440 converts them to the same units; format the result as a time to display it clearly.

Why the Formula Uses 1,440

Excel represents dates and times with serial numbers: whole-number portions count days, and the decimal portion represents the fraction of a day. One day has 24 hours, or 1,440 minutes. For instance, 30 minutes is 30/1,440 of a day, which is 0.0208333…

That is why subtracting a number such as 30 directly from a time does not mean “subtract 30 minutes.” It subtracts 30 days from the underlying serial value. Dividing the minutes by 1,440 converts them into Excel’s time units before subtraction.

Enter and Format the Formula

Enter a starting time in A1, such as 3:45 PM.
Enter the number of minutes to subtract in B1, such as 25.
In another cell, enter =A1-B1/1440.
Format the result cell as a time if it appears as a decimal or a number.

With those values, the result is 3:20 PM. The formula follows the usual order of operations: Excel divides B1 by 1,440 first, then subtracts that fraction of a day from A1. Parentheses make the conversion especially clear: =A1-(B1/1440).

To format a cell, select it and use the time format in the number-format controls on the Home tab. You can also open Format Cells and choose a time format. A format such as h:mm AM/PM displays a 12-hour clock; hh:mm displays a 24-hour clock. Formatting changes how the value appears, not the calculation itself.

Examples for Common Situations

The same formula works with a fixed number of minutes or a value in a cell:

Subtract 15 minutes from A1: =A1-15/1440
Subtract the minutes in B1 from A1: =A1-B1/1440
Subtract different amounts by row: enter =A2-B2/1440 in the result row, then fill the formula down.
Subtract minutes from the current time: =NOW()-15/1440. This returns a date and time, because NOW includes both; format the result to show the part you need.

If the number of minutes is in a cell that may contain a decimal, Excel can calculate fractional minutes too. For example, 2.5 minutes is two minutes and 30 seconds. If you need whole-minute input only, keep the input as an integer or use data validation to restrict entries.

Subtracting Across Midnight

Excel times can cross midnight, but a cell containing only a time does not show a date. If you subtract 20 minutes from 12:10 AM, the actual result is 11:50 PM on the previous day. Depending on the cell’s number format and whether the calculation has a date component, Excel may display a negative-time result as a row of number signs or otherwise fail to show a normal clock time.

For a clock-only answer that should wrap around within a 24-hour day, use =MOD(A1-B1/1440,1). The MOD function returns the remainder within one day, so 12:10 AM minus 20 minutes displays as 11:50 PM. This is useful for recurring daily schedules, but it deliberately discards the date change. For records where the previous day matters, enter full dates and times, such as 11/8/2026 12:10 AM, and subtract the minutes from that date-time value. Then format the result to show both date and time.

Duration Values and Common Mistakes

A clock time and an elapsed duration are related but not identical. A clock time such as 3:45 PM indicates a point on the day; a duration such as 25 minutes indicates an amount of elapsed time. Excel stores both as fractions of a day, which makes the same conversion work, but the display format should match the meaning.

Typing minutes directly: =A1-25 subtracts 25 days, not 25 minutes. Use 25/1440.
Seeing a decimal: the calculation may be right; change the result’s number format to a time format.
Confusing minutes and hours: to subtract hours, divide the hours by 24. To subtract seconds, divide seconds by 86,400.
Using a 12-hour time without AM or PM: Excel may interpret an ambiguous entry differently than intended. Include AM/PM or enter a 24-hour time.
Getting a negative result: check whether the time crosses midnight and whether the formula needs a full date or a MOD wrapper.

For totals or elapsed durations longer than 24 hours, use a duration format such as [h]:mm. The square brackets allow hours to accumulate past 24 instead of restarting at zero. For a simple clock display, h:mm resets at each day boundary, as a clock normally does.

Alternative Formulas

If your minutes are in B1, =A1-TIME(0,B1,0) is another readable option. TIME takes hours, minutes, and seconds and returns a time value. It normalizes values that exceed the usual range, so it can also handle inputs such as 90 minutes. As with direct subtraction, a result that crosses midnight may need a date or a wrapping formula depending on the intended display.

You can also express the conversion as =A1-B1/(24*60). This is mathematically the same as dividing by 1,440 and can make the units visible: 24 hours per day times 60 minutes per hour. Choose whichever version is easiest for someone maintaining the workbook to understand.

Frequently Asked Questions

What is the Excel formula to subtract 30 minutes?
Use =A1-30/1440 if A1 contains the starting time. If the minutes are in B1, use =A1-B1/1440.

Why does Excel use 1,440 to subtract minutes?
Excel stores time as a fraction of a day, and a day contains 1,440 minutes. Dividing a minute count by 1,440 converts it into a fraction Excel can subtract from a time.

How do I subtract minutes and keep the result between midnight and 11:59 PM?
Use =MOD(A1-B1/1440,1). It wraps the result into a single day, but it does not preserve whether the calculation moved to the previous date.

How can I subtract minutes from a time and show the date too?
Enter a full date and time in A1, subtract with =A1-B1/1440, and format the result to display both date and time. This preserves the date change when the calculation crosses midnight.

How do I subtract seconds or hours instead?
For seconds, use =A1-B1/86400, because there are 86,400 seconds in a day. For hours, use =A1-B1/24, because there are 24 hours in a day.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.