Excel Formula for Adding Hours, Minutes & Seconds

To add hours, minutes, and seconds in Excel, you simply use the SUM function on cells formatted as time, or enter times directly like =A1+TIME(1,30,15) to add 1 hour, 30 minutes, and 15 seconds. The result displays correctly only if the cells are formatted with a time format, such as h:mm:ss.

Formula

The most direct formula is:

=A1 + TIME(hours, minutes, seconds)

Where:

• A1 – the cell containing the original time (must be a valid Excel time).
• hours – the number of hours to add (can be any positive number).
• minutes – the number of minutes to add (0–59 for the TIME function, but you can use larger values and Excel will roll over).
• seconds – the number of seconds to add (0–59, same rollover applies).

Excel stores times as fractions of a day. For example, 12:00 noon is stored as 0.5. Adding 1 hour is equivalent to adding 1/24, and adding 1 minute is 1/(24*60). The TIME function handles these conversions automatically.

Worked Example

Using the default values from the calculator above:

• Start time: 2:30:00 (cell A1)
• Hours to add: 1
• Minutes to add: 30
• Seconds to add: 15

The formula becomes:

=A1 + TIME(1,30,15)

Step by step:

1. Convert 1 hour to a fraction of a day: 1/24 = 0.0416667
2. Convert 30 minutes to a fraction: 30/(24*60) = 30/1440 = 0.0208333
3. Convert 15 seconds to a fraction: 15/(24*60*60) = 15/86400 = 0.0001736
4. Add all to the start time: 2:30:00 (which is 0.1041667) + 0.0416667 + 0.0208333 + 0.0001736 = 0.1668403
5. Convert back to time: 0.1668403 * 24 = 4.00417 hours = 4 hours, 0 minutes, 15 seconds.

So the result is 4:00:15.

Adding Multiple Time Cells

If you have a column of times and want the total, use the SUM function:

=SUM(A1:A10)

This works as long as all cells are formatted as time. The result will be shown in the same time format. However, if the total exceeds 24 hours, the display will wrap around (e.g., 25:00:00 shows as 1:00:00). To fix this, apply a custom number format: [h]:mm:ss – the square brackets around h tell Excel to show total hours beyond 24.

Adding Hours, Minutes, Seconds from Separate Cells

Sometimes you have the hours, minutes, and seconds in separate cells (e.g., B1=1, C1=30, D1=15). You can combine them with the TIME function:

=A1 + TIME(B1, C1, D1)

Or, if you want to add them to a start time stored in A1, the same formula works. If you need to add a duration that is stored as text like “1:30:15”, you can use TIMEVALUE:

=A1 + TIMEVALUE("1:30:15")

Common Mistakes and Pitfalls

• Not formatting the result cell as time. If the cell is General, you’ll see a decimal like 0.1668 instead of 4:00:15. Always apply a time format.
• Using 24-hour time incorrectly. Excel treats times as fractions of a day, so 24:00:00 is the same as 0:00:00 (midnight). For durations over 24 hours, use the [h]:mm:ss format.
• Entering times as text. If you type “2:30:00” with a leading apostrophe or in a text-formatted cell, Excel won’t treat it as a time. Use the TIME function or format the cell as time before entering.
• Forgetting that minutes and seconds roll over. The TIME function automatically converts 75 minutes to 1 hour and 15 minutes. That’s usually what you want, but if you need to keep minutes as a separate count, you’ll need a different approach.

Using the Calculator Above

The calculator at the top of this page does the same thing as the Excel formula. You enter a start time, then the hours, minutes, and seconds you want to add. It returns the sum in hh:mm:ss format. This is handy for quick checks or when you don’t have Excel open.

Frequently Asked Questions

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

Use =A1 + TIME(0,30,0) or simply =A1 + 30/1440 because there are 1440 minutes in a day. The TIME function is more readable.

Why does my time sum show as 1:00:00 when it should be 25:00:00?

Excel’s default time format resets at 24 hours. To show total hours beyond 24, select the cell, press Ctrl+1, choose Custom, and type [h]:mm:ss.

Can I add times that are in different formats, like 1:30 PM and 2:45:30?

Yes, as long as Excel recognizes both as times. 1:30 PM is stored as 0.5625 (13.5 hours after midnight), and 2:45:30 is 2.7583 hours. Adding them gives a time of day, not a duration. If you want a duration, convert the PM time to a duration by subtracting the start time of the day.

What if I want to add hours and minutes without seconds?

Use =A1 + TIME(hours, minutes, 0). The seconds argument is optional; you can omit it or set it to 0.

How do I add a duration in days, hours, minutes, and seconds?

You can combine days separately: =A1 + days + TIME(hours, minutes, seconds). For example, to add 2 days, 5 hours, 30 minutes, and 15 seconds: =A1 + 2 + TIME(5,30,15).

Is there a way to add times without using the TIME function?

Yes, you can directly add the decimal fractions: =A1 + hours/24 + minutes/1440 + seconds/86400. This is what the TIME function does internally, but it’s less readable.

Related

• Steam Next Fest Demos vs Game Trials: Key Differences
• GTA Online Smoke on the Water Product Locations & Rewards
• Listen Audio Bible Offline: How It Works

in t1 | Start time | hh:mm:ss | 2:30:00 | 0
in add_h | Hours to add | h | 1 | 0
in add_m | Minutes to add | min | 30 | 0
in add_s | Seconds to add | s | 15 | 0
out result | Sum | hh:mm:ss | t1 + TIME(add_h, add_m, add_s) | time