ThisCalculator

Everyday

Excel Subtract Dates to Get Minutes

Updated · Standard formula, shown below

The calculator for this page is switched off while it is checked. The formula is below, and the worked example in the article shows how to use it by hand.

To subtract dates in Excel and get the difference in minutes, use the formula =(End_Date - Start_Date)*1440, where 1440 is the number of minutes in a day. This works because Excel stores dates as serial numbers where 1 equals 24 hours, so subtracting two dates gives the difference in days, and multiplying by 1440 converts that to minutes.

Formula

The core formula is:

Minutes = (End Date/Time – Start Date/Time) × 1440

Where:

  • End Date/Time – the later date and time value (Excel serial number)
  • Start Date/Time – the earlier date and time value (Excel serial number)
  • 1440 – the number of minutes in one day (24 hours × 60 minutes)

Excel stores every date and time as a decimal number. The integer part represents days since January 1, 1900 (or 1904 on Mac), and the fractional part represents the time of day. For example, 1.5 means 1 day and 12 hours, which is 36 hours or 2160 minutes.

Worked Example

Using the default values from the calculator above:

  • Start: 2025-01-01 08:00
  • End: 2025-01-01 09:30

Step 1: Subtract the start from the end:
2025-01-01 09:30 – 2025-01-01 08:00 = 0.0625 (days)

Step 2: Multiply by 1440:
0.0625 × 1440 = 90 minutes

So the result is 90 minutes, which matches the calculator output.

Why Excel Treats Dates as Numbers

Understanding Excel’s date system is key to getting correct minute differences. Excel assigns serial numbers to dates: January 1, 1900 is serial 1, January 2, 1900 is 2, and so on. Time is added as a fraction of a day: 6:00 AM is 0.25, 12:00 PM is 0.5, 6:00 PM is 0.75. When you subtract two date/time cells, Excel returns a decimal number representing the exact number of days between them. This is why multiplying by 1440 gives minutes.

If you only subtract time values that are within the same day, you can also use =(End Time – Start Time)*1440 directly, but this fails if the end time is on the next day (e.g., 11:00 PM to 1:00 AM). Including full dates avoids that issue.

How to Apply the Formula in Excel

To use this in a worksheet:

  1. Enter your start date/time in cell A1, e.g., 2025-01-01 08:00.
  2. Enter your end date/time in cell B1, e.g., 2025-01-01 09:30.
  3. In cell C1, type: =(B1-A1)*1440.
  4. Press Enter. The result appears as a number (e.g., 90).

If the result shows as a time (like 1:30), change the cell format to “Number” or “General” via the Home tab. Also ensure both cells contain real date/time values, not text. You can verify by checking that the cell is right-aligned by default; text is left-aligned.

Common Mistakes and How to Avoid Them

  • Forgetting to multiply by 1440 – subtracting dates alone gives days, not minutes. Always multiply.
  • Text-formatted dates – if your dates are text, the subtraction returns a #VALUE! error. Use DATEVALUE() or re-enter as dates.
  • Formatting result as time – Excel may show the result as a time fraction (e.g., 1:30) instead of 90. Change the number format.
  • Negative results – if the start date is after the end date, you get a negative number. This is mathematically correct, but if you need absolute minutes, wrap with ABS(): =ABS((B1-A1)*1440).
  • Daylight saving time – Excel does not automatically adjust for DST; it treats all times as standard. If your data spans a DST change, the minute difference may be off by 60 minutes.

Alternatives to the Multiplication Formula

If you prefer not to remember 1440, you can use the DATEDIF function, but note that DATEDIF does not handle minutes directly. For minutes, you can calculate days and hours separately:

  • =DATEDIF(A1,B1,"d")*1440 + (B1-A1)*1440 – this is redundant but works.
  • =TEXT(B1-A1,"[m]") – this returns the total minutes as a text string, but the result is text, not a number, so it can’t be used in further calculations.
  • =MINUTE(B1-A1) – this only returns the minutes portion (0-59), not the total minutes across days.

For most cases, the simple =(B1-A1)*1440 is the most direct and reliable.

Working with Time Durations Over 24 Hours

If your time difference exceeds 24 hours, the multiplication formula still works because the serial number difference can be greater than 1. For example, from 2025-01-01 08:00 to 2025-01-03 08:00 gives a serial difference of 2.0, and multiplying by 1440 gives 2880 minutes. There is no need for special handling unless you want to display the result as hours and minutes. To show it as “48:00” (hours:minutes), use the format [h]:mm on the cell after dividing by 1440? Actually, if you keep the result in minutes, format it as a number. If you want a duration display, use =(B1-A1) and apply the custom format [h]:mm to show total hours and minutes.

Frequently Asked Questions

Why does my formula return a time like 1:30 instead of 90?

Excel automatically applies a time format to cells when you subtract dates. The underlying value is still correct (90 minutes), but the display shows it as 1:30 (1 hour 30 minutes). To see the number, select the cell, go to the Home tab, and change the number format to “Number” or “General”.

How do I get minutes between two times that cross midnight?

If your times are only times (not full dates), use =MOD((B1-A1),1)*1440 to handle the crossing. For example, 11:00 PM to 1:00 AM: =MOD((1/24 - 23/24),1)*1440 gives 120 minutes. But it’s safer to include full dates in your cells.

Can I subtract dates in different cells and get minutes without a formula?

No, Excel does not have a built-in “minutes between” button. You must use a formula. The simplest is =(B1-A1)*1440.

What if my dates are in separate columns for date and time?

Combine them first: =DATE(year,month,day)+TIME(hour,minute,0) to create a single date/time value, then subtract. For example, if date is in A1 and time in B1, use =(A1+B1)-(C1+D1) where C1 and D1 are the start date and time.

Why does my result show as a date like 1/2/1900?

This happens when the result is formatted as a date. The number 90 formatted as a date shows as 1/2/1900 (because Excel counts from 1900). Change the format to Number to see 90.

Is there a way to get minutes as a whole number without decimals?

Yes, use =ROUND((B1-A1)*1440,0) to round to the nearest minute. Or use =INT((B1-A1)*1440) to truncate.

Related

Formula used
in t | Start date/time | - | 2025-01-01 08:00 | 0
in d | End date/time | - | 2025-01-01 09:30 | 0
out pace | Minutes difference | min | (d - t) * 1440 | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

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