To add minutes to an Excel time, add the minutes divided by 1,440: with a time in A2 and a number of minutes in B2, enter =A2+B2/1440. Format the result as a time, such as h:mm; Excel stores time as part of a day, and there are 1,440 minutes in a day.
The basic formula for adding minutes
Put the starting time in one cell and the number of minutes to add in another. For example, enter 9:15 AM in A2 and 35 in B2. With that layout, use =A2+B2/1440 in C2. The result is 9:50 AM when C2 is formatted as a time. The minutes cell can contain a whole number or a decimal, so adding 2.5 minutes is possible if that precision is useful.
The division by 1,440 converts minutes into Excel’s units. Excel represents a full day as 1, so one hour is 1/24 and one minute is 1/1,440. The formula does not change the starting time; it adds a fraction of a day to its stored value. You can fill the formula down a column to calculate results for many rows, provided each row has a starting time in column A and minutes in column B.
If you prefer a function that explicitly describes hours and minutes, Excel’s TIME function can also do the conversion. With the starting time in A2 and minutes to add in B2, enter =A2+TIME(0,B2,0). For example, if A2 is 9:15 AM and B2 is 35, the result is 9:50 AM. For ordinary minute amounts, both approaches are appropriate; dividing by 1,440 makes the underlying time conversion especially clear.
How Excel stores time
Excel stores dates as serial numbers and times as decimal fractions of a day. A time such as noon is one half of a day, while 6:00 AM is one quarter. The cell’s number format controls how that value appears: the same underlying number might be displayed as a clock time, a date and time, or a decimal.
This explains why adding a plain number of minutes directly to a time usually gives an unexpected result. If A2 contains 9:15 AM and B2 contains 35, the formula =A2+B2 treats 35 as 35 whole days, not 35 minutes. Divide the minutes by 1,440, or use TIME, so the amount being added is expressed in Excel’s time units.
It also explains why formatting matters. A correct calculation can appear wrong if the result cell is set to General, a date format, or a duration format that does not match the question. Changing the display format does not alter the stored calculation; it changes only how Excel presents it.
Set up the worksheet and format the result
For a simple calculation, use a clear layout: column A for the starting time, column B for minutes to add, and column C for the result. Enter actual Excel times in A2, such as 9:15 AM, and numeric values in B2. Then enter the formula in C2. If the result shows as a decimal or an unexpected date, apply a time format rather than changing the formula.
- Select the result cell or result range.
- On Windows, press Ctrl+1 to open Format Cells. On Mac, press Command+1.
- Choose the Number tab, select Time, and choose a suitable display such as 1:30 PM. You can also choose Custom and enter h:mm or h:mm AM/PM.
- Select OK and check that the displayed result matches the intended clock time.
For a reusable worksheet, label the minutes column clearly and make sure the values are numbers, not text such as 35 min. A cell containing a number and a cell containing text may look similar but behave differently in arithmetic. If you need the worksheet to show a unit, keep the numeric value in its own cell and put the label in a neighboring heading.
Examples with different minute amounts
With a starting time in A2 and minutes in B2, the same formula works for short and long additions. If A2 is 8:40 AM and B2 is 20, =A2+B2/1440 returns 9:00 AM. If A2 is 8:40 AM and B2 is 90, it returns 10:10 AM. The second example crosses an hour boundary, but no special formula is needed because Excel’s time value naturally carries into the next hour.
To subtract minutes, use a negative number in B2 or subtract the converted minutes. With a time in A2 and a positive number of minutes in B2, the formula =A2-B2/1440 subtracts those minutes. For instance, starting at 9:15 AM and subtracting 35 minutes gives 8:40 AM. A negative value in B2 with the addition formula gives the same result, but a subtraction formula may be easier for other people to read.
You can also add a fixed number without a separate minutes cell. With the starting time in A2, enter =A2+30/1440 to add 30 minutes. Keeping the amount in a separate cell is generally more convenient when the value may change or when you need to copy the calculation for multiple records.
Adding minutes across midnight
A time-only value does not identify a particular date. If A2 is 11:30 PM and B2 is 90, the result is one hour after midnight. With the formula =A2+B2/1440 and a standard clock format such as h:mm AM/PM, Excel displays 1:00 AM. That display is correct as a time of day, but it does not tell you that the result falls on the following date.
If the date matters, include it in the starting value. For example, enter both a date and time in A2, such as November 2, 2026 at 11:30 PM, and use 90 in B2. With that layout, =A2+B2/1440 returns a date-time value on November 3, 2026 at 1:00 AM. Format the result to show both date and time if you need to make the date change visible. This is useful for appointments, shift schedules, travel times, and task deadlines.
If you intentionally want only a clock reading that wraps back to the start of the day, use MOD. With a time in A2 and minutes in B2, =MOD(A2+B2/1440,1) returns a time between midnight and just before the next midnight. This removes the whole-day part, so it is unsuitable when the date or elapsed days must be retained.
Clock time versus elapsed duration
A clock time answers what time of day something happens. An elapsed duration answers how much time has passed. They need different display formats when the total exceeds 24 hours. For example, adding 1,500 minutes to a time-only value adds 25 hours. A regular h:mm format shows the clock position after the extra day, while the stored value still includes the full duration.
To show total hours rather than wrapping after 24, format the result with the custom format [h]:mm. The square brackets tell Excel to display cumulative hours. With a time in A2 and 1,500 in B2, =A2+B2/1440 represents 25 hours beyond the starting value; the bracketed format displays the accumulated hours and minutes. By contrast, h:mm displays the time-of-day portion. Choose the format based on whether readers need a clock reading or a total duration.
For an elapsed interval between two date-time values, use the later date-time minus the earlier one and display the result as [h]:mm. A regular time format can make durations longer than a day look as if they have wrapped, even though the calculation is sound.
Common problems and how to fix them
- The answer is a large number or date. The result may be correct but displayed in General or a date format. Format it as a time, or use [h]:mm for accumulated hours.
- The result is far too large. Check that the formula divides the minutes by 1,440. Adding the raw minute count adds days because Excel interprets 1 as one full day.
- The formula returns an error. Confirm that the starting value is a valid Excel time and the minutes cell is numeric. Text such as 35 minutes is not the same as the number 35.
- A result after midnight appears earlier than the start time. A time-only display wraps at midnight. Include the date if you need to show the next day, or use a duration format if you need total hours.
- Negative times show as hash marks. Excel’s default 1900 date system generally cannot display negative date-time values as ordinary clock times. Check whether the calculation should be negative, and consider a text display or a different calculation design if negative durations are required.
When checking a surprising result, inspect both the formula bar and the number format. The formula bar helps confirm the stored value or formula, while the format explains how that value is being displayed. Avoid replacing a valid result with a manually typed time just to make it look right; doing so can break later calculations.
Choosing a formula for your situation
For most worksheets, =A2+B2/1440 is a straightforward choice because it works with a numeric minutes input and makes the conversion explicit. TIME is readable when you want to construct an amount from hours, minutes, and seconds, but it is not necessary merely to add minutes. MOD is appropriate only when you deliberately want the answer to wrap within a single day.
Choose the number format separately from the formula. Use h:mm or h:mm AM/PM for a clock reading, include a date format when the calendar day matters, and use [h]:mm for an accumulated duration. In Excel for Microsoft 365 on Windows, these formats are available through Format Cells; the keyboard shortcut is Ctrl+1. On Mac, use Command+1 to open the corresponding Format Cells dialog.
In Excel for the web, you can also apply number formats from the Home tab’s Number Format controls. The calculation itself is the same. If the workbook is shared across desktop and web versions, use standard Excel formulas and formats, then check that the displayed result communicates whether it is a time of day or a duration.
Frequently Asked Questions
How do I add 15 minutes to a time in Excel?
With the starting time in A2, enter =A2+15/1440 and format the result as a time. If you prefer to keep the number of minutes in B2, use =A2+B2/1440 with 15 in B2.
Can I add minutes without dividing by 1,440?
Yes. With a time in A2 and the minutes to add in B2, enter =A2+TIME(0,B2,0). Dividing by 1,440 is another valid method and directly reflects the fact that a day contains 1,440 minutes.
Why does adding minutes show a decimal?
Excel may be displaying the result as General or Number. Select the result cell and apply a time format such as h:mm. Formatting changes the appearance, not the stored value.
How do I make Excel show the next day after adding minutes?
Include a date as well as a time in the starting cell, then add the minutes. Format the result to show both date and time; a time-only format can display 1:00 AM without indicating which date it belongs to.
How do I display more than 24 hours?
Format the result with the custom number format [h]:mm. The brackets display cumulative hours instead of restarting the hour count after each day.
Related
- Power Query Union Tables: How to Append Queries
- Data Validation: Definition, Rules, and Examples
- Excel Data Validation Date Picker: Setup and Options
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Timesheet Calculator Formula: Examples and TipsFor an Excel timesheet with start time in B2, end time in C2, and an unpaid break duration…
- Excel MATCH Arguments: What Each One DoesExcel’s MATCH function has three arguments: MATCH(lookup_value, lookup_array, [match_type]). The first two say what to look for and…
- Recursive LAMBDA in Excel: Examples That WorkRecursive LAMBDA formulas call themselves to repeat a calculation, such as finding a factorial or stepping through a…
- Excel Compare Two Sheets: Tools, Formulas, and TipsTo compare two Excel sheets, use Spreadsheet Compare if it is available in your Microsoft 365 or Office…
- Sort Excel Alphabetically: Rows, Columns, and ListsTo sort a list alphabetically in Excel for Microsoft 365 on Windows, select a cell in the column,…
- Concat Excel Multiple Cells: Formulas, Spaces, and TipsTo concat (combine) multiple cells in Excel, use =CONCAT(A2:C2) to join the values in A2 through C2 without…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.