If A2 contains a start date and time and B2 contains an end date and time, enter =(B2-A2)*1440 to return the elapsed time in minutes. Excel stores each day as a number, so multiplying the difference by 1,440 converts days to minutes.
Calculate elapsed minutes between two date-times
Use the basic subtraction formula when both cells contain a real Excel date-time value. For example, suppose A2 is 2/12/2025 9:15 AM and B2 is 2/12/2025 1:45 PM. With the start in A2 and the end in B2, enter =(B2-A2)*1440. The result is 270 minutes: the interval is 4 hours and 30 minutes, and 4.5 × 60 equals 270.
The formula measures elapsed time, not the difference between the minute numbers shown on a clock. It accounts for both the date and the time in each cell. If the dates differ, that extra time is included automatically. For instance, a period that crosses midnight is calculated correctly if the cells contain complete date-times.
Copy the formula down a column to calculate many intervals. If your data is in an Excel table, you can also use a structured-reference formula; for a table with columns named Start and End, enter =([@End]-[@Start])*1440 in a new table column. Excel generally fills the calculated column for the other rows.
Why multiplying by 1,440 works
Excel represents dates and times as serial numbers. The whole-number portion represents the day count, while the fractional portion represents a part of a day. For example, 12 hours is one-half of a day, and 6 hours is one-quarter of a day. Subtracting one date-time from another therefore gives a result measured in days.
There are 24 hours in a day and 60 minutes in an hour, so 24 × 60 = 1,440 minutes in a day. Multiplying the subtraction result by 1,440 changes the unit from days to minutes. The same principle works for seconds: a day contains 86,400 seconds, so multiplying a date-time difference by 86,400 gives seconds.
Excel stores time as a fraction rather than as a separate kind of value. A cell displayed as 9:15 AM is still a numeric value, which is why ordinary subtraction can calculate a duration. The cell’s display format controls what you see; it does not change the underlying arithmetic.
Use dates without times
If the cells contain dates only, the formula still works. With a start date in A2 and an end date in B2, enter =(B2-A2)*1440. For example, January 1, 2025 to January 3, 2025 is two days, so the result is 2,880 minutes. This counts the full elapsed time between the date values, not just working hours or minutes during a business day.
Check what the dates mean in your task. If a record says an event began on one date and ended on another but provides no times, treating each date as midnight is Excel’s natural calculation. That may be suitable for calendar-day intervals, but it cannot reveal the actual elapsed minutes if the event began or ended partway through either day.
Handle times that cross midnight
If cells contain times only, subtracting the end time from the start time can produce a negative result when the interval crosses midnight. For an interval known to finish on the following day, use MOD to wrap the result into a 24-hour day. With a start time in A2 and an end time in B2, enter =MOD(B2-A2,1)*1440.
For example, a start time of 10:50 PM and an end time of 1:20 AM gives 150 minutes with this formula: 1 hour and 10 minutes to midnight, followed by 1 hour and 20 minutes after midnight. This works for a single overnight interval shorter than 24 hours.
Time-only values do not tell Excel which date an event belongs to. Consequently, MOD assumes the end is later and wraps the difference into the next day. If both times are identical, the result is zero, not 1,440 minutes. If a shift can last 24 hours or more, use complete date-times in the input cells instead; a time-only formula cannot distinguish a 30-minute interval from one lasting 24 hours and 30 minutes.
Display the result clearly
The formula multiplied by 1,440 returns a numeric count of minutes. Format the result cell as Number or General so it displays a value such as 270. In Excel for Microsoft 365 on Windows, select the formula cell and use Home > Number Format to choose Number. On Mac, use the number-format controls on the Home tab; the calculation is the same. Excel for the web also calculates the formula, though some formatting controls may be arranged differently.
A different approach is to keep the subtraction result in Excel’s day-based units and display it as a duration. With the start date-time in A2 and end date-time in B2, enter =B2-A2, then apply a custom format such as [h]:mm. The brackets make hours accumulate beyond 24, so a 27-hour interval displays as 27:00 rather than wrapping to 3:00. A custom format of [m] displays the total elapsed minutes from that day-based result. Open Format Cells and choose a custom number format to apply either style.
Do not confuse those displays with a formula that already multiplies by 1,440. A result of 270 from the minutes formula is already 270 minutes; applying a duration format to it treats 270 as days and makes the display misleading. Choose either a numeric answer in minutes or a day-based duration display, according to how you want to use the result.
Choose whether to round the answer
The basic formula can return fractional minutes when the timestamps include seconds. For example, 30 seconds is 0.5 minutes. If you want the nearest whole minute, with the start in A2 and end in B2, use =ROUND((B2-A2)*1440,0). ROUND changes the displayed numeric result to the nearest integer; it does not alter the original date-time values.
Choose a rounding rule that fits the purpose of the calculation. Rounding to the nearest minute can make a report easier to read, but it may not be appropriate when exact elapsed time matters. If you need to count only fully completed minutes for a positive interval, use =INT((B2-A2)*1440), with the start in A2 and end in B2. INT rounds down to the next lower integer. For a positive result, that drops any partial minute; for negative values, it rounds toward negative infinity, which may not be the same as truncating toward zero.
Keep the unrounded formula in the source calculation when later totals need precision. Formatting a cell to show zero decimal places changes only the display, while ROUND changes the value returned by the formula. That distinction matters when adding many short intervals: rounding every row first can produce a different total from summing exact durations and rounding only the final total.
Common errors and checks
- The result looks like a date or clock time: The formula may be correct, but the result cell is formatted as a date or time. Change it to Number or General when the formula returns minutes.
- The formula returns a negative value: The end value is earlier than the start value. Check for swapped columns, an incorrect date, or a missing next-day date. Use the MOD approach only when you know the interval crosses midnight and the inputs are times without dates.
- The formula returns an error or an unexpected value: One or both inputs may be text rather than Excel date-time values. Text that looks like a date is not always stored as a date; regional date conventions can also make entries such as 3/4 ambiguous. Check whether Excel recognizes the values as dates, and convert or re-enter them consistently if needed.
- The result is off by a factor of 1,440: Check whether the subtraction result is still in days or has already been converted to minutes. Multiply by 1,440 once, not twice.
- Totals differ slightly from expectations: The cells may contain seconds that are hidden by their display format. Increase the displayed precision or inspect the source timestamps before deciding whether to round.
Also verify that the end date and time are recorded correctly. A common data-entry issue is entering a time on the right date but omitting the date change after midnight. Excel cannot infer a missing date reliably from a complete date-time pair.
What this calculation does not measure
Subtracting date-times gives ordinary elapsed minutes. It does not exclude weekends, holidays, lunch breaks, or nonworking hours. For example, a Friday afternoon start and a Monday morning end includes the entire weekend. A business-time calculation needs additional rules and data, such as working hours and a holiday list; the simple date-difference formula is not a working-minutes calculator.
Excel date-times also do not automatically carry time-zone or daylight-saving information. If timestamps come from different time zones, convert them to a common time basis before subtracting. Around daylight-saving changes, a local clock interval can differ from the actual elapsed time. Excel’s stored values alone do not resolve that ambiguity.
For most ordinary records, enter consistent date-times in both cells and subtract them. If your workbook uses inputs from multiple systems, confirm that the systems use the same time zone and that the values are genuine dates rather than text labels. These checks help prevent a mathematically correct formula from giving an answer that misrepresents the real event.
Frequently Asked Questions
How do I calculate the number of minutes between two dates in Excel?
Subtract the earlier date-time from the later one and multiply by 1,440. If the start is in A2 and the end is in B2, use =(B2-A2)*1440. Format the answer as Number or General to see the minute count.
Can Excel calculate minutes between times on different days?
Yes. Include the date as well as the time in both cells, then subtract and multiply by 1,440. For times without dates that cross midnight, MOD can wrap the result into the next day, but it cannot identify intervals of 24 hours or longer.
Why does my answer show as a decimal?
The timestamps may include seconds, so the elapsed time may be a fraction of a minute. Use ROUND if you specifically want a whole-minute result, or change the cell’s decimal display without changing the underlying value.
Does DATEDIF return the total minutes between dates?
No. DATEDIF calculates differences in units such as years, months, or days, not total elapsed minutes. For total minutes, subtract the date-time values and multiply the result by 1,440.
How do I show elapsed time longer than 24 hours?
Keep the subtraction result in day-based units and apply the custom duration format [h]:mm. The square brackets show cumulative hours instead of restarting the hour count at each 24-hour boundary. If you need a numeric count of minutes instead, multiply the date-time difference by 1,440.
Related
- Comparison Excel Sheet Template: Build a Clear Side-by-Side
- Comparison Plot in Excel With R²: Steps and Meaning
- Company Invoice Template in Excel: Setup and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- EDATE in Excel: Add Months to a Date, With ExamplesTo add calendar months to a date in Excel, use =EDATE(start_date, months). For example, with a date in…
- Excel Filter for Specific Text: Steps and ExamplesTo filter Excel rows for specific text in Microsoft 365 on Windows, select a cell in your data,…
- Excel XLOOKUP Function Examples for Everyday LookupsIn Excel for Microsoft 365, XLOOKUP finds a value in one range and returns the corresponding value from…
- Excel Power Query Table Filter: How to Apply and RefreshTo filter an Excel table with Power Query in Microsoft 365 for Windows, select a cell in the…
- How to Find Standard Deviation in Excel With FormulasTo find standard deviation in Excel, enter =STDEV.S(B2:B9) for a sample or =STDEV.P(B2:B9) for an entire population, replacing…
- How to Sort Excel Alphabetically by First ColumnTo sort an Excel list alphabetically by its first column, click a cell in that column and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.