How to Add Hours in Excel: Formulas, Formats, and What to Watch Out For

Adding hours in Excel sounds straightforward — until your totals show "2:00" when you expected "26:00," or a formula spits out a decimal instead of a time. Excel handles time in a way that trips up a lot of users, and understanding the mechanics makes all the difference between a spreadsheet that works and one that silently gives you wrong answers.

How Excel Actually Stores Time

Before touching a formula, it helps to know what Excel is really doing under the hood. Excel stores time as a fraction of a day. One full day equals the number 1. So:

• 6 hours = 0.25
• 12 hours = 0.5
• 18 hours = 0.75
• 24 hours = 1.0

When you type "6:00" into a cell, Excel isn't storing the text "6:00" — it's storing 0.25 and displaying it in a time format. This is why adding hours works mathematically, but also why formatting becomes critical when totals exceed 24 hours.

Basic Method: Using SUM to Add Hours ⏱️

The simplest way to add hours in Excel is with the SUM function, the same one you'd use for any numbers.

If your time entries are in cells B2 through B8:

Excel adds the underlying decimal values and returns a result. If your total comes to less than 24 hours, a standard time format like h:mm will display it correctly.

You can also add individual time cells directly:

Both approaches work. SUM is cleaner for longer ranges.

The 24-Hour Overflow Problem

Here's where most people run into trouble. If your total hours exceed 24, Excel's default time format resets to zero and starts counting again — just like a clock rolling past midnight.

For example, if you've logged 30 hours across a week, Excel might display 6:00 instead of 30:00. The underlying value is correct; only the display is wrong.

The fix is a custom number format. Select the cell containing your total, open Format Cells (Ctrl+1 on Windows, Cmd+1 on Mac), go to Number → Custom, and type:

The square brackets around h tell Excel to display the total accumulated hours rather than wrapping at 24. This single change resolves the most common hour-addition mistake in Excel.

Adding a Specific Number of Hours to a Time Value

Sometimes you need to add a fixed number of hours to an existing time — for example, calculating an end time when you know the start time and duration.

Because Excel stores time as fractions of a day, you divide your hours by 24:

Where A2 contains a start time and B2 contains the number of hours to add (entered as a plain number like 3 or 8, not as a time).

Alternatively, you can use the TIME function to build the offset:

TIME(hours, minutes, seconds) constructs a time value Excel understands. This approach is readable and avoids manual division, though it has a ceiling — TIME won't handle values of 24 hours or more correctly on its own. For durations under 24 hours, it's reliable and clean.

Working With Hours and Minutes Together

If your data includes both hours and minutes (like timesheet entries of "1:45" or "2:30"), adding them with SUM still works — Excel handles the fractional math automatically.

A common need is then converting the result into decimal hours for payroll or billing. To convert a time total to a decimal number:

Multiplying by 24 converts the day-fraction back into hours as a regular number. Format that cell as a Number (not a Time), and you'll get a value like 37.5 instead of 13:30.

Common Errors and What Causes Them

Seeing ###### — The column is too narrow to display the value. Widen it.

Getting a decimal instead of a time — The result cell isn't formatted as time. Apply a time format via Format Cells.

Total shows wrong hours after midnight — You're working with timestamps that cross midnight. Excel interprets a later time on the same day as smaller than an earlier time, so subtraction goes negative. You may need to add 1 (one full day) conditionally, or include date values alongside your times.

TIME function returns unexpected results for large durations — TIME wraps at 24 hours. For durations of 24 hours or more, use the division method (hours/24) instead. 🔢

How Your Use Case Shapes the Right Approach

The method that works best depends on what kind of time data you're handling:

• Simple timesheets with daily hour entries under 24 hours each → SUM with [h]:mm format covers it.
• Project tracking where tasks run into multi-day durations → dividing by 24 and working with decimals tends to be more reliable.
• Scheduling or shift planning where you're calculating end times from start times → TIME() or the division method with proper date-time formatting matters more.
• Payroll or billing exports that need decimal hours → the *24 conversion is essential.

The version of Excel you're using (desktop vs. Excel Online vs. Excel on Mac) doesn't change these core formulas, but some formatting dialogs look different across platforms. The logic is consistent — the cell formatting behavior and where you find custom format options may vary slightly.

Whether you're building a simple weekly log or a more complex time-tracking system, the underlying question is the same: what does your data look like, and what does the output need to represent? That's what determines which combination of formula and format actually fits your spreadsheet.