ThisCalculator

Everyday

Get Total Minutes from Time in Excel: Step-by-Step

Updated · Standard formula, shown below

This guide shows you how to convert any time value in Excel (like 2:30 PM or 14:30) into total minutes (870, in this case). You’ll learn the basic multiplication method, how to handle times that cross midnight, and how to format the result correctly so Excel doesn’t show a confusing decimal or a time-of-day instead of a plain number.

What You’ll Need

  • Microsoft Excel (2010 or later; the steps are the same in Excel for Microsoft 365, Excel 2021, 2019, and 2016)
  • A cell containing a time value (e.g., a start time, duration, or timestamp)
  • A blank cell where you want the total minutes to appear

Step-by-Step

  1. Identify the cell with your time. For example, let’s say cell A1 contains the time 2:30 PM (Excel stores it as the number 0.60417).
  2. Click on the cell where you want the result. Let’s use B1.
  3. Type the formula: =A1*1440 and press Enter. That’s it. The number 1440 is the number of minutes in a day (24 hours × 60 minutes). Excel multiplies the time (which is a fraction of a day) by 1440 to get total minutes.
  4. Check the result. For 2:30 PM, you should see 870. If you see something like 0.60417, the cell is formatted as a number, not as a time – see the Common Mistakes section below.
  5. If you want a whole number (no decimals), wrap the formula in the INT function: =INT(A1*1440). This rounds down to the nearest whole minute, which is useful when your time includes seconds and you only want full minutes.
  6. For times that cross midnight (e.g., start 11:00 PM, end 1:00 AM), you need a different formula if you’re calculating the duration between two times. If you have a single time value that represents a duration (like 26:00 for 26 hours), skip to Step 8. For a difference between two times where the end is on the next day, use: =(B1-A1+(B1 where A1 is start and B1 is end. The (B1 part adds 1 (a full day) if the end is earlier than the start.
  7. If your time is stored as text (e.g., you typed '2:30 PM with an apostrophe), Excel won't calculate it. Convert it first: use =TIMEVALUE(A1)*1440 to turn the text into a real time, then multiply by 1440.
  8. For durations over 24 hours (like 26:15), the time must be entered with the format [h]:mm. If you type 26:15 into a cell, Excel might interpret it as 2:15 AM on the next day. To force it as a duration, format the cell as [h]:mm first (Format Cells > Number > Custom > Type: [h]:mm). Then the formula =A1*1440 will give 1575 minutes.
  9. For a column of times, copy the formula down. Use the fill handle (the small square at the bottom-right of the cell) to drag the formula to other rows.

Common Mistakes

  • Forgetting to multiply by 1440. If you just use =A1, you'll get a decimal like 0.60417, not 870.
  • Cell formatted as time. After multiplying, if the cell is formatted as 'Time' (e.g., h:mm), Excel will show 14:30 instead of 870. Fix: right-click the cell > Format Cells > Number > General (or Number).
  • Using 60 instead of 1440. Some people try =A1*60, which gives the number of seconds in a day fraction, not minutes. 1440 is correct.
  • Not handling midnight crossing. If you subtract a start time from an end time without the (B1 adjustment, you get a negative fraction or a wrong result.
  • Text times. If the cell is left-aligned and has a green triangle, it's likely text. Use TIMEVALUE first.

Tips

  • Use the TIME function for clarity: For a known time like 2:30 PM, you can write =TIME(14,30,0)*1440 to avoid any entry ambiguity.
  • Round to nearest minute: Use =ROUND(A1*1440,0) to round to the nearest whole minute instead of truncating with INT.
  • Format as number with zero decimals: After entering the formula, set the cell format to Number with 0 decimal places for a clean look.
  • Use for payroll or billing: If you need minutes for hourly billing, this method is faster than manual conversion.
  • Keyboard shortcut: Press Ctrl+1 to open Format Cells quickly.

Troubleshooting

  • Result shows 0.60417 instead of 870: The cell is formatted as a number. Select the cell, press Ctrl+1, choose 'Number' under Category, set decimal places to 0, and click OK.
  • Result shows 14:30: The cell is formatted as a time. Change the format to 'General' or 'Number' as above.
  • Result is a negative number: This happens when you subtract a later time from an earlier time without the midnight-crossing adjustment. Use =(B1-A1+(B1.
  • Result is a #VALUE! error: The cell contains text or a non-time value. Check if the cell is left-aligned. Use =TIMEVALUE(A1)*1440 if it's text, or re-enter the time as a proper time (e.g., type 2:30 PM with a space).
  • Result is a #NUM! error: The time is negative or invalid. Ensure your time is between 0 and 1 (or a valid duration).
  • Result is a decimal like 870.5: That's correct if your time includes seconds (e.g., 2:30:30 PM = 870.5 minutes). If you want whole minutes, use INT or ROUND.

Frequently Asked Questions

Why multiply by 1440 and not 60?

Excel stores times as fractions of a 24-hour day. One hour is 1/24, so one minute is 1/1440. Multiplying by 1440 converts the fraction to minutes.

How do I convert a time like 1:30 PM to 810 minutes?

Use =A1*1440. For 1:30 PM, Excel sees 0.5625, and 0.5625 × 1440 = 810.

What if my time is in the format hh:mm:ss?

The same formula works. For example, 1:30:45 gives 90.75 minutes (1 hour = 60, 30 min = 30, 45 sec = 0.75).

Can I convert a duration like 26:15 (26 hours 15 minutes) to minutes?

Yes, but the cell must be formatted as [h]:mm first. Then =A1*1440 gives 1575 minutes.

How do I convert a time difference that crosses midnight?

Use =(B1-A1+(B1. For example, start 11:00 PM, end 1:00 AM gives 120 minutes.

Why does my formula return a decimal like 870.5?

That's correct for times with seconds. 2:30:30 PM is 870.5 minutes. Use INT or ROUND to get a whole number.

Related

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