Excel Time Difference in Minutes: Formulas and Tips

To calculate the minutes between a start time in A2 and an end time in B2, enter =(B2-A2)*1440 in another cell and format the result as a number. For example, 9:15 AM to 10:45 AM returns 90 minutes.

The basic minutes formula

Assume A2 contains the start time and B2 contains the end time, both on the same day. The formula =(B2-A2)*1440 subtracts the start from the end and converts the resulting fraction of a day into minutes. Enter it in C2, then fill it down for other rows if needed. If A2 is 9:15 AM and B2 is 10:45 AM, the elapsed time is 1.5 hours, so the result is 90.

The multiplier is 1,440 because a day has 24 hours and each hour has 60 minutes: 24 × 60 = 1,440. Excel stores a time as a fraction of a day, rather than as a separate number of minutes. Consequently, simply subtracting the two time cells gives a fraction such as 0.0625 for 90 minutes. Multiplying by 1,440 converts that fraction into a useful minute count.

Keep the result cell separate from the time inputs. A clear table might have Start in column A, End in column B, and Minutes in column C. If your times are in different cells, replace A2 and B2 in the formula with the appropriate references. Excel formulas use commas between function arguments when arguments are needed; this basic subtraction formula has no function arguments.

How Excel stores times

Excel represents dates and times as serial numbers. In the conventional date system, whole-number portions represent days and the decimal portion represents the time within a day. Noon is halfway through a day, for example. This is why subtracting one time from another produces a fraction and why multiplying by 1,440 produces minutes.

This storage model also explains why input values need to be real Excel times rather than text that only looks like a time. Type values such as 9:15 AM or 14:30 into cells and check that Excel recognizes them as times. A value aligned or formatted unexpectedly may be text; text subtraction can return a #VALUE! error. Changing the display format does not convert text into a numeric time.

Minutes can be fractional when the interval includes seconds. For instance, 30 seconds is 0.5 minute. That is mathematically correct, and you can decide whether to keep the precision or round it for reporting. If the source times are rounded to whole minutes, the result will reflect that input precision.

Intervals that cross midnight

When A2 contains a start time and B2 an end time on the following day, ordinary subtraction produces a negative difference because Excel sees the end clock reading as earlier. If you know the interval is less than 24 hours and the end time is earlier than the start time because the shift crossed midnight, use =MOD(B2-A2,1)*1440. With A2 at 10:00 PM and B2 at 2:00 AM, this returns 240 minutes.

MOD wraps a negative time difference around one full day. This is convenient for simple overnight shifts, but it assumes the elapsed interval is under 24 hours. It cannot tell whether 2:00 AM means the next day, the same day, or a date several days later. If shifts may last a full day or more, include dates with the times and subtract the complete date-time values instead.

Do not use the midnight formula automatically for every row if some end times are genuinely earlier for another reason, such as a data-entry error. Wrapping the result would turn that apparent error into a plausible positive duration. A review of the input rows is important whenever a calculation treats an earlier end time as the next day.

Using dates as well as times

For real appointments, shifts, or events that can span midnight, enter a date and time in each cell. Assume A2 contains the full start date and time and B2 contains the full end date and time. Use =(B2-A2)*1440. For a start of November 2 at 10:00 PM and an end of November 3 at 2:00 AM, the result is 240. Because the dates are included, the formula also works for intervals longer than one day.

Make sure both entries include the correct date. If the end cell has only a time, Excel cannot infer which date it belongs to in a multi-day calculation. You can display the inputs in a readable date-and-time format while keeping the output as a number of minutes. The underlying values remain numeric regardless of how the cells are displayed.

For a running list of date-time intervals, use one start and one end value per row and calculate each row independently. This makes it easier to spot an end date entered before its start date. It also avoids relying on a formula that assumes every earlier clock time means the next calendar day.

Rounding minutes and subtracting breaks

Whether to round depends on what the result represents. For payroll or operational records, follow the relevant policy rather than rounding by habit. Assume A2 is a start time and B2 an end time; to round the computed minutes to the nearest whole minute, use =ROUND((B2-A2)*1440,0). If the interval is 12 minutes and 30 seconds, this returns 13. Without ROUND, the result retains the fractional minute.

For a shift that crosses midnight and lasts less than 24 hours, with A2 as the start time and B2 as the end time, round the overnight result with =ROUND(MOD(B2-A2,1)*1440,0). Rounding to the nearest minute is different from always rounding up or down. Excel also has ROUNDUP and ROUNDDOWN functions, but use them only when that specific rounding direction is intended.

To deduct an unpaid break, assume A2 is the start time, B2 is the end time, and C2 contains the break duration as an Excel time, such as 0:30 for 30 minutes. Use =((B2-A2)-C2)*1440. For a same-day shift from 8:00 AM to 4:30 PM with a 30-minute break, the calculation is 510 minutes minus 30 minutes, or 480 minutes. If the shift crosses midnight, account for the overnight interval when calculating the gross duration before subtracting the break.

Formatting the result correctly

A minutes formula should usually display as a number, such as 90, not as a clock time. Select the result cells and choose Home > Number Format, then select General or Number. Number is useful when you want a consistent number of decimal places; General is often sufficient for whole-minute results. If the cell displays a clock value, the calculation may still be right, but the cell is formatted to show a time rather than a minute count.

To inspect or change a cell’s formatting, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then choose an appropriate number category. In Excel for the web, use the Number Format controls on the Home tab; the exact dialog options can differ from the desktop application. Formatting changes how a value appears, not the underlying calculation.

If instead you want the elapsed duration displayed as hours and minutes, keep the result as a time difference rather than multiplying it into minutes. For a duration that can exceed 24 hours, apply the custom number format [h]:mm through Format Cells > Number > Custom. The square brackets make the hours accumulate instead of restarting at zero after each 24-hour period. This is a display choice; it is not the same as returning a plain numerical count of minutes.

Common errors and misleading results

A result appears as a clock time. Set the result cell to General or Number if you used the minutes formula. A time format interprets the numeric result as a fraction of a day for display.
The formula returns a negative number or #######. Check whether the end is earlier than the start. For a known overnight interval under 24 hours, use the MOD method. A negative value displayed with a time format may appear as hash marks under Excel’s usual date system.
You see #VALUE!. One or both inputs may be text rather than valid numeric times. Re-enter them as times, or convert the source data before calculating. A display that resembles a time does not prove that Excel stored it as one.
The duration is off by a factor of 60 or 1,440. Check the units. Subtraction returns a fraction of a day; multiplying by 1,440 gives minutes, while multiplying by 24 gives hours.
A night shift has an implausibly long result. Confirm whether the end date is correct and whether you used a time-only overnight calculation for an interval that spans more than one day.

When checking a result, calculate the interval in familiar units as a sanity check. A 90-minute difference should be 1 hour and 30 minutes. That simple comparison catches many cases where the right subtraction was performed but the conversion multiplier or output format was wrong.

Minutes, decimal hours, and displayed durations

Minutes are often best for billing increments, task tracking, and reports that require a single count. Decimal hours can be more convenient for summaries: 90 minutes equals 1.5 hours. If A2 is the start time and B2 the end time on the same day, =(B2-A2)*24 returns decimal hours. The result for 9:15 AM to 10:45 AM is 1.5.

A displayed duration such as 1:30 is more familiar for schedules and timesheets, but it is not the same appearance as a numeric 90. Choose the representation that matches the next step in your work. For arithmetic and reporting, numeric minutes or decimal hours are straightforward; for a human-readable elapsed duration, an hours-and-minutes format may be clearer.

Do not confuse a clock reading with elapsed time. The difference between 11:30 PM and 12:30 AM is one hour if the second time is on the next day. A clock display alone does not contain enough information to establish that date relationship; include dates when the context requires them.

Frequently Asked Questions

How do I calculate the difference between two times in minutes in Excel?
Put the start time in A2 and the end time in B2, then enter =(B2-A2)*1440 in another cell. Format the result as General or Number so it displays as minutes.

How do I calculate time in minutes if it passes midnight?
For a time-only interval under 24 hours, with start in A2 and end in B2, use =MOD(B2-A2,1)*1440. If the interval can exceed 24 hours, enter the date and time in both cells and use the direct date-time difference instead.

Why does Excel show a decimal instead of minutes?
Subtracting times alone returns a fraction of a day. Multiply that result by 1,440 to convert it to minutes. If the result is still shown as a clock reading, change the cell’s number format to General or Number.

How can I show the result as hours and minutes instead?
Use the time difference as a duration and format the result as hours and minutes. For totals that may exceed 24 hours, use the custom format [h]:mm so the displayed hours do not reset each day.

Can Excel calculate minutes between full date-and-time values?
Yes. With the complete start date and time in A2 and the complete end date and time in B2, =(B2-A2)*1440 returns elapsed minutes, including across midnight and across multiple days.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.