ThisCalculator

Everyday

Calculate Minutes from Time in Excel

Updated · Standard formula, shown below

To calculate minutes from time in Excel, subtract the start time from the end time, then multiply the result by 1440 (the number of minutes in a day). For example, =(B2-A2)*1440 returns the total minutes between two times when formatted as a number.

Why Excel Stores Time as Fractions of a Day

Excel treats time as a decimal fraction of a 24-hour day. 12:00 PM is stored as 0.5, 6:00 AM as 0.25, and so on. This design allows arithmetic operations on times, but it also means that a simple subtraction like =B2-A2 gives a fraction, not minutes. To convert that fraction into minutes, you multiply by 1440 because there are 24 hours × 60 minutes in a day.

For example, if you enter 9:00 AM in A2 and 5:30 PM in B2, the raw difference is 0.3541667 (8.5 hours). Multiplying by 1440 yields 510, which is exactly the number of minutes from 9:00 AM to 5:30 PM.

Basic Formula to Get Minutes Between Two Times

The core formula is:

=(EndTime - StartTime) * 1440

If the result appears as a time (like 8:30), change the cell format to Number or General (Home → Number Format → General).

Here is a step-by-step example:

  1. In A2, type 9:00 AM (or 9:00 if using 24-hour format).
  2. In B2, type 5:30 PM (or 17:30).
  3. In C2, enter =(B2-A2)*1440.
  4. Press Enter. Excel shows 510 if the cell is formatted as a number.

To keep the formula from showing a time, you can also wrap it in VALUE() or simply format the cell as a number.

Handling Times That Cross Midnight

If your start time is 11:00 PM and the end time is 2:00 AM the next day, a simple subtraction gives a negative fraction because Excel sees 2:00 AM as smaller than 11:00 PM. To fix this, add 1 to the end time when the start time is later:

=(B2 - A2 + (B2 < A2)) * 1440

The (B2 < A2) part returns TRUE (which Excel treats as 1) when the end time is before the start time, effectively adding a full day. For 11:00 PM to 2:00 AM, the formula gives 180 minutes (3 hours).

Be aware that this method assumes the gap is less than 24 hours. If you need to track durations longer than a day, include the date in your cells (e.g., 2025-01-01 23:00) and use the same formula without the (B2 < A2) adjustment.

Converting a Single Time Value to Minutes

Sometimes you need the minutes since midnight for one time. For example, to convert 2:30 PM to minutes:

=A2 * 1440

If A2 contains 2:30 PM, the result is 870 (14.5 hours × 60). This works because Excel stores 2:30 PM as 0.6041667, and multiplying by 1440 gives the total minutes.

You can also use the HOUR and MINUTE functions:

=HOUR(A2)*60 + MINUTE(A2)

This returns the same 870. The direct multiplication is simpler, but the HOUR/MINUTE version is clearer if you want to show the breakdown.

Common Mistakes and How to Avoid Them

  • Forgetting to multiply by 1440 – The raw subtraction gives a fraction of a day, not minutes. Always multiply.
  • Result shows as a time (like 8:30) – This happens when the cell format is set to Time. Right-click the cell → Format Cells → Number → General.
  • Negative times for overnight shifts – Use the +(B2 < A2) adjustment or include dates.
  • Mixing time formats – Ensure both cells are true time values, not text. If you type times with a space (e.g., “9:00 AM”), Excel usually recognizes them, but text like “9:00 AM ” (trailing space) can cause errors.
  • Rounding errors – Excel’s floating-point arithmetic can produce tiny decimals (like 509.9999999). Use =ROUND((B2-A2)*1440, 0) to get a whole number.

Using the MINUTE Function vs. Multiplying

The MINUTE function extracts the minute component of a time (0–59). For example, =MINUTE("3:45 PM") returns 45. It does not convert the whole time to minutes. This is a common point of confusion.

If you want the total minutes from midnight, use multiplication. If you want just the minute part (for example, to compare whether two times are in the same minute), use MINUTE.

For a duration between two times, you must subtract first, then multiply. There is no single function that returns the total minutes directly, but you can use HOUR and MINUTE together:

=(HOUR(B2)*60 + MINUTE(B2)) - (HOUR(A2)*60 + MINUTE(A2))

That works but is longer than the multiplication method.

Formatting the Result as Minutes and Seconds

If you want the result to display as minutes and seconds (e.g., 8:30 for 8 minutes 30 seconds), you can use the TEXT function:

=TEXT((B2-A2)*1440/1440, "mm:ss")

But that returns text, not a number. Better to keep the numeric value and format the cell as [m]:ss (custom format). The brackets [m] show total minutes even if over 60. For example, 90 minutes displays as 90:00, not 1:30.

To apply: right-click the cell → Format Cells → Custom → type [m]:ss.

Frequently Asked Questions

How do I calculate minutes between two times in Excel?

Subtract the start time from the end time and multiply by 1440: =(End-Start)*1440. Format the result as a number. If the times cross midnight, use =(End-Start+(End<Start))*1440.

Why does my formula return a time like 8:30 instead of 510?

Because the cell is formatted as a time. Select the cell, go to the Home tab, and change the Number Format to General or Number. The underlying value is correct; only the display format is wrong.

How do I convert a time like 2:30 PM to minutes in Excel?

Multiply the time cell by 1440. If the time is in A1, =A1*1440 gives 870. Alternatively, use =HOUR(A1)*60+MINUTE(A1).

What if my time difference is more than 24 hours?

Include the date in your time cells (e.g., 2025-01-01 23:00). Then subtract normally and multiply by 1440. The (End<Start) adjustment is not needed because the date makes the end time larger.

Can I use the MINUTE function to get the total minutes?

No. MINUTE returns only the minute component (0–59). To get total minutes, multiply the time by 1440 or use HOUR and MINUTE together.

Why does my result show 510.0000001 instead of 510?

Excel uses binary floating-point arithmetic, which can cause tiny rounding errors. Wrap the formula in =ROUND((B2-A2)*1440, 0) to get a clean whole number.

Related

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