ThisCalculator

Everyday

Time Calculator Minutes Excel: How to Add & Format

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 calculate time in minutes in Excel, you typically subtract a start time from an end time and then convert the result to minutes by multiplying by 1440 (the number of minutes in a day). This article explains the formulas, formatting, and common pitfalls so you can accurately add, subtract, and display minutes in your spreadsheets.

Why Excel Time Calculations Confuse People

Excel stores times as fractions of a 24-hour day. For example, 6:00 AM is stored as 0.25, and 12:00 noon as 0.5. This means that when you subtract two times, you get a decimal that represents a fraction of a day, not minutes or hours directly. To get minutes, you must multiply by 1440 (24 hours × 60 minutes). This is the core concept behind every time calculation in Excel.

The Basic Formula: Converting Time to Minutes

If you have a start time in cell A1 and an end time in cell B1, the elapsed time in minutes is:

=(B1-A1)*1440

This works because the difference (B1-A1) is a fraction of a day, and multiplying by 1440 converts it to minutes. For example, if A1 = 9:00 and B1 = 10:30, the difference is 0.0625 days, and multiplying by 1440 gives 90 minutes.

Adding Minutes to a Time

To add a certain number of minutes to a time, you divide the minutes by 1440 and add that to the time. For example, to add 90 minutes to the time in A1:

=A1 + 90/1440

If you want the result to display as a time, format the cell as “HH:MM”. If you want the result in minutes (e.g., total minutes since midnight), multiply by 1440 after adding.

Formatting Cells Correctly

Proper formatting is essential. If you enter a time like “9:00” Excel might interpret it as text or as a time, depending on your locale. Always use the format “HH:MM” or “HH:MM:SS” for time cells. To apply this, right-click the cell, choose Format Cells, then select Time under the Number tab. For results that are minutes, use a number format like “0” or “General”.

Common Mistakes and How to Avoid Them

  • Multiplying by 60 instead of 1440 – If you multiply a time difference by 60, you get hours, not minutes. Always use 1440 for minutes.
  • Using text times – If your time is entered as text, Excel cannot calculate with it. Convert text to time using the TIMEVALUE function.
  • Negative time results – If your end time is earlier than your start time (e.g., overnight shift), Excel may show a negative or ##### error. Use the MOD function: =MOD(B1-A1,1)*1440 to handle overnight times.
  • Displaying as a decimal instead of time – If you add minutes and the result shows 0.0625, you need to format the cell as a time, not a number.

Using the Calculator Above

The calculator at the top of this page adds a duration in minutes to a start time and shows the end time. Enter a start time in HH:MM format (e.g., 9:00) and a duration in minutes (e.g., 90). The result is the end time in 24-hour format. This is useful for scheduling, shift planning, or any task that requires adding a fixed number of minutes to a known start.

For example, if you start work at 9:00 AM and a task takes 90 minutes, the calculator shows the end time as 10:30. The formula behind it is: end_time = start_time + (minutes/1440).

Alternatives: Using Excel’s Built-in Time Functions

Excel offers several functions that can simplify time calculations:

  • TIME(hour, minute, second) – Creates a time value from its components.
  • HOUR(), MINUTE(), SECOND() – Extracts parts of a time.
  • TIMEVALUE() – Converts a text string that looks like a time into a time value.
  • NOW() – Returns the current date and time; useful for tracking elapsed time.

For example, to convert 90 minutes into a time value, you could use =TIME(0,90,0), which gives 1:30 (one hour and thirty minutes).

Frequently Asked Questions

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

If cell A1 contains 1:30 (meaning 1 hour 30 minutes), use the formula =A1*1440 and format the result as a number. This gives 90 minutes. If A1 is text, first convert it with =TIMEVALUE(A1)*1440.

Why does my time subtraction show #####?

This happens when the result is negative or when the column is too narrow. If your end time is earlier than your start time (e.g., 10:00 PM to 2:00 AM), Excel returns a negative value. Use =MOD(B1-A1,1)*1440 to get the correct positive minutes. Also widen the column to see the value.

How do I add up a column of minutes in Excel?

If you have a column of times (like durations), you can sum them with the SUM function. However, if the total exceeds 24 hours, you need to format the result as “[h]:mm” to display total hours beyond 24. For minutes, multiply the sum by 1440.

Can I calculate time in minutes without using 1440?

Yes. You can use the HOUR and MINUTE functions: =HOUR(B1-A1)*60 + MINUTE(B1-A1). This extracts the hours and minutes separately and combines them. It’s more verbose but avoids the 1440 multiplier.

What if my time is entered as a decimal like 9.5 for 9:30?

If you use decimal hours, you can simply multiply by 60 to get minutes. For example, 9.5 hours × 60 = 570 minutes. But if you mix decimal and time formats, you’ll get errors. Be consistent.

Related

Formula used
in t | Start time (HH:MM) | - | 9:00 | 0
in d | Duration (minutes) | min | 90 | 0
out end | End time | clock | (hour(t)*60+minute(t)+d) | 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.