How to Add Time in Excel: Formulas, Functions, and Formatting Explained

Working with time values in Excel can feel deceptively tricky. Time looks like a number you'd type normally, but Excel stores it differently under the hood — and once you understand that, everything clicks into place.

How Excel Actually Stores Time

Before touching a formula, it helps to know what Excel is doing with time behind the scenes. Excel represents time as a decimal fraction of a 24-hour day. Midnight is 0, noon is 0.5, and 6:00 PM is 0.75. This means time values are just numbers — which is exactly why you can add them with ordinary arithmetic.

When you type 3:30 into a cell and press Enter, Excel stores it as approximately 0.1458. The cell displays3:30 because of the number format applied, but the underlying value is that decimal. This distinction matters a lot when your addition results look wrong.

Basic Time Addition Using the + Operator

The simplest way to add time in Excel is with a plus sign, exactly like adding any numbers.

If cell A1 contains 2:30 (2 hours, 30 minutes) and cell B1 contains 1:45, then:

=A1+B1 

Returns 4:15 — provided the result cell is formatted as time.

This works reliably when you're adding durations that stay under 24 hours total. The moment the sum crosses the 24-hour threshold, Excel's default time format wraps back to zero, which is one of the most common sources of confusion.

Adding Time That Exceeds 24 Hours ⏱️

If you're tracking cumulative hours — say, total weekly work hours or project time logs — your totals will likely exceed 24 hours. Excel's standard h:mm format doesn't display this correctly by default.

The fix: Apply a custom number format using square brackets around the hour unit.

1. Select the result cell
2. Press Ctrl + 1 to open Format Cells
3. Go to Number → Custom
4. Enter [h]:mm in the Type field

The square brackets tell Excel to display the total elapsed hours rather than resetting at 24. A result of 26 hours and 15 minutes will show as 26:15 instead of 2:15.

Using the TIME Function to Add Specific Durations

When you want to add a fixed amount of time — like adding 90 minutes to a start time — the TIME function is the cleanest approach.

=A1+TIME(hours, minutes, seconds) 

For example, to add 1 hour and 30 minutes to a value in A1:

=A1+TIME(1,30,0) 

This is especially useful when the increment comes from user input or a variable, since TIME constructs a valid Excel time value from separate components. You can also reference other cells within the TIME function arguments.

Summing a Range of Time Values

For totaling multiple time entries — a log of daily hours, for instance — SUM works directly on time values:

=SUM(A1:A10) 

No special syntax needed. Apply the [h]:mm custom format to the result cell if the total might exceed 24 hours.

Adding the Current Time With NOW() and TODAY()

Excel has two volatile functions that insert current date/time information:

• =NOW() — returns the current date and time as a combined value
• =TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW())) — extracts just the current time component

These recalculate every time the workbook recalculates, which makes them useful for timestamps but unreliable for fixed records. If you need a static current time that doesn't update, use the keyboard shortcut Ctrl + Shift + ; to insert the current time as a fixed value.

Common Formatting Pitfalls 🔍

Several issues trip people up when adding time in Excel:

Result shows as a decimal number — The cell isn't formatted as time. Select it, go to Format Cells, and choose Time or apply a custom format like h:mm.

Negative time values — Excel for Windows doesn't display negative time by default. If you're subtracting time and might get a negative result, you either need to enable the 1904 date system (under File → Options → Advanced) or restructure your formula to avoid it.

Text formatted as time — If time was imported from another system or typed with inconsistent formatting, Excel may store it as text rather than a real time value. A quick check: right-align means it's a number, left-align usually means text. Use TIMEVALUE() to convert text strings to proper time values.

Variables That Affect Which Approach Works Best

The right method for adding time in Excel depends on several factors specific to your situation:

• What you're tracking — scheduling, duration, elapsed time, and timestamps each behave differently and may need different formulas or formats
• Your Excel version — some formatting shortcuts and function behaviors vary between Excel 2016, 2019, Microsoft 365, and Excel for Mac or web
• Whether data is imported — externally sourced time data often arrives as text, requiring conversion before arithmetic works reliably
• Total duration range — if sums will always stay under 24 hours, standard formatting is fine; cumulative totals demand the [h]:mm format
• How dynamic the values need to be — static timestamps, auto-updating times, and formula-driven calculations each call for different tools

The mechanics of time addition in Excel are consistent, but which specific combination of functions, formats, and approaches produces the right result depends on what your spreadsheet is actually doing — and what the data looks like when it arrives.