ThisCalculator

Everyday

Excel Formula: Add Minutes to Time

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.

Excel Formula: Add Minutes to Time

To add minutes to a time in Excel, use the formula =A1 + TIME(0, minutes, 0), where A1 contains the original time and minutes is the number of minutes to add. Alternatively, you can simply add the minutes divided by 1440 (the number of minutes in a day), like =A1 + minutes/1440. This article explains both methods, how they work, and common pitfalls to avoid.

Formula

Excel stores times as fractions of a day. Midnight is 0, noon is 0.5, and 6:00 PM is 0.75. Therefore, to add minutes, you can either use the TIME function or divide the minutes by 1440.

  • Using TIME: =A1 + TIME(0, minutes, 0) – the TIME function creates a time value from hours, minutes, and seconds.
  • Using division: =A1 + minutes/1440 – since there are 1440 minutes in a day, dividing by 1440 converts minutes to the corresponding fraction of a day.

Both formulas return a time value. If the result exceeds 24 hours, Excel will show a time on the next day unless you format the cell with [h]:mm to display total hours.

Worked Example

Using the default values from the calculator: start time 9:30 AM, add 45 minutes.

  1. Convert 9:30 AM to a fraction: 9.5 hours / 24 = 0.3958333…
  2. Convert 45 minutes to a fraction: 45 / 1440 = 0.03125
  3. Add: 0.3958333 + 0.03125 = 0.4270833
  4. Convert back to time: 0.4270833 * 24 = 10.25 hours = 10:15 AM

The result is 10:15 AM, which matches the calculator output.

When to Use Each Method

The TIME function is more readable and less error-prone when you are adding a fixed number of minutes. The division method is useful when the minutes are in a cell and you want to avoid the overhead of a function. Both produce identical results.

If you need to add hours and minutes together, use =A1 + TIME(hours, minutes, 0) or =A1 + hours/24 + minutes/1440.

Common Mistakes and How to Avoid Them

  • Forgetting to format the result as time: If the cell shows a decimal like 0.427, apply a time format (e.g., h:mm) from the Number Format dropdown.
  • Adding minutes directly: =A1 + 45 adds 45 days, not 45 minutes. Always divide by 1440 or use TIME.
  • Using 24-hour vs. 12-hour confusion: Excel stores times in 24-hour format internally. If you type 9:30, it is 9:30 AM. To enter 9:30 PM, type 21:30 or 9:30 PM with the format.
  • Overflow past midnight: If the result is after midnight, Excel will show a time on the next day. To display total hours (e.g., 26:15), use the custom format [h]:mm.

How to Read the Result

The result is a time of day, not a duration. For example, adding 45 minutes to 11:30 PM gives 12:15 AM (the next day). If you need the total elapsed time (e.g., 24:15), format the cell with [h]:mm.

When the result is used in further calculations, remember it is still a fraction of a day. To convert it to hours, multiply by 24; to minutes, multiply by 1440.

Alternatives and Related Formulas

  • Subtracting minutes: Use a negative number or the minus sign: =A1 - TIME(0, minutes, 0) or =A1 - minutes/1440.
  • Adding seconds: =A1 + TIME(0, 0, seconds) or =A1 + seconds/86400.
  • Adding a duration in h:mm format: If the duration is in a cell as text, use =A1 + TIMEVALUE(duration_cell).
  • Using NOW() for current time: =NOW() + TIME(0, 30, 0) adds 30 minutes to the current date and time.

Frequently Asked Questions

Why does my formula show a decimal instead of a time?

Excel stores times as decimals. To display it as a time, select the cell, go to the Home tab, and choose a time format from the Number Format dropdown. You can also use the custom format h:mm.

How do I add minutes to a time that includes a date?

If the cell contains a date and time (e.g., 2025-03-01 9:30), the same formulas work. The result will include the date, and if the time crosses midnight, the date will roll over automatically.

Can I add minutes to a time entered as text?

If the time is text like “9:30”, use =TIMEVALUE("9:30") + TIME(0, 45, 0). This converts the text to a time value first. Otherwise, Excel may not recognize it as a number.

What if I need to add a variable number of minutes from a list?

Put the minutes in a cell, say B1, and use =A1 + B1/1440. You can fill the formula down for multiple rows. Make sure the minutes are numeric, not text.

How do I add 30 minutes to a time in Excel without a formula?

You can use Paste Special: enter 0:30 in a cell, copy it, select the times, right-click > Paste Special > Add. This adds 30 minutes to each selected time.

Why does my result show as 12:00 AM when adding minutes?

This usually happens when the result is exactly midnight, or when the cell is formatted to hide the date portion. If you add 30 minutes to 11:30 PM, the result is 12:00 AM (midnight). To see the date, use a format like m/d/yyyy h:mm.

Related

Formula used
in t | Start time (HH:MM) | - | 9:30 | 0
in m | Minutes to add | min | 45 | 0
out result | New time | clock | t + m | 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.