The simplest way to add hours in Excel

To add hours in Excel, put each time value in its own cell, then use a formula that sums them. The most straightforward approach is to type =SUM() with the cell range inside the parentheses. For example, if you have hours in cells A1 through A5, you would type =SUM(A1:A5) in an empty cell below them and press Enter.

Excel stores time as a decimal fraction of a 24-hour day, so when you add hours together, the result is technically correct but may display in a format that looks wrong at first. A cell showing "1:30" plus "2:15" will correctly total "3:45", but if your result shows something like "0.15625" instead, the cell is just formatted as a number rather than as time. The fix is straightforward: format the result cell as time, and the hours will display correctly.

This method works whether your times are entered as hours and minutes (like 2:30), as decimal hours (like 2.5), or as a mix. Excel handles the math the same way regardless.

Key Takeaways

  • Use the SUM formula with a cell range to add multiple time entries at once: type =SUM(A1:A5) and press Enter.
  • If your total shows as a decimal number instead of hours and minutes, right-click the cell, choose Format Cells, and select Time format.
  • You can add times entered as hours:minutes, as decimal hours, or as a mix—Excel performs the calculation the same way.
  • For times that span past 24 hours, use the time format [h]:mm so the hours display as a number larger than 24 instead of rolling over to the next day.

Setting up your spreadsheet to track hours

Start by creating column headers so you know what each column contains. In cell A1, type a label like "Date" or "Task", then in B1 type "Hours Worked" or "Time In", and in C1 type "Time Out" if you are tracking start and end times. This layout makes it clear what data goes where and helps you spot mistakes later.

Enter your time values directly below each header. If you are typing times as hours and minutes, use the format 2:30 (for 2 hours 30 minutes) or 14:45 (for 2:45 PM in 24-hour time). Excel will recognize these as time values automatically. If you prefer to enter decimal hours—like 2.5 for 2 hours 30 minutes—that works too, but you may need to format the result differently when you sum them.

Leave at least one empty row or cell below your data where you will place your total. This keeps the sum separate from the individual entries and makes the spreadsheet easier to read.

Using SUM to add multiple time entries

Click on the empty cell where you want your total to appear. Type =SUM(, then click on the first cell with a time value and drag down to the last cell with a time value. Excel will automatically fill in the cell range. Then type the closing parenthesis ) and press Enter.

If your times are in cells B2 through B10, the formula will be =SUM(B2:B10). When you press Enter, Excel calculates the total and displays it in that cell. The formula bar at the top of the screen will show your formula so you can check it is correct.

You can also type the range manually if you prefer. Click the cell where you want the total, type =SUM(B2:B10), and press Enter. Both methods produce the same result.

Fixing time format when the result looks wrong

After you create a SUM formula, the result might display as a decimal like 0.625 instead of as hours and minutes like 15:00. This happens because the cell is formatted as a number rather than as time. The calculation is correct—0.625 of a 24-hour day equals 15 hours—but the display is confusing.

To fix this, right-click on the cell containing your total and select Format Cells from the menu. A dialog box will open. Click the Number tab if it is not already selected, then look for Time in the Category list on the left side. Click Time, then choose a format from the list on the right. The format 13:30:55 (hours:minutes:seconds) is the most common. Click OK and your total will now display as hours and minutes.

If your total is more than 24 hours—for example, if you are adding up a full week of work—the standard time format will "roll over" and show only the hours past 24. To display the full hour count, use the format [h]:mm instead. This format shows hours as a number larger than 24 when needed, so 30 hours displays as 30:00 instead of 6:00.

Adding times when you have start and end times

If your spreadsheet has a "Time In" column and a "Time Out" column, you first need to calculate how many hours elapsed between them, then sum those durations. In a new column (like column D), create a formula that subtracts the start time from the end time: =C2-B2 (if C2 is the end time and B2 is the start time). Copy this formula down for each row.

The result will show the duration for each entry. Then, in an empty cell below, use =SUM(D2:D10) to add all the durations together. Format this total cell as time using the steps above. If your durations span more than 24 hours, remember to use the [h]:mm format so the full hour count displays.

This approach works even if some entries cross midnight—for example, a shift that runs from 11:00 PM to 7:00 AM the next day. Excel handles the calculation correctly as long as you enter the times in the same format throughout.

Handling times entered as decimal hours

If your hours are entered as decimals—like 2.5 for 2 hours 30 minutes, or 8.75 for 8 hours 45 minutes—you can still use SUM to add them. Type =SUM(A1:A5) as usual, and Excel will add the decimal values correctly.

The result will display as a decimal number. If you want to convert this back to hours and minutes format, multiply the result by 24 first. For example, if your sum is 0.375 (which represents 9 hours in decimal form), multiply it by 24 to get 9, then format the cell as a number with two decimal places to show 9.00. Alternatively, if you want the result in hours:minutes format, you can use a more complex formula, but for most purposes, keeping decimal hours as decimals is simpler.

The key point is that decimal hours and hours:minutes format are two different ways of representing the same thing. Choose whichever format matches how you entered your original data, and stick with it throughout the spreadsheet to avoid confusion.

Copying formulas down to calculate totals for multiple groups

If you have multiple weeks, projects, or people in the same spreadsheet, you can create a SUM formula for each group without retyping it. After you create your first total formula, click on the cell containing it, then look for a small square in the bottom-right corner of the cell. Click and drag this square downward to copy the formula to the cells below.

Excel automatically adjusts the cell references as it copies. If your first formula is =SUM(B2:B10), the next row down will become =SUM(B11:B19), and so on. This saves time and reduces the chance of typing errors when you have many groups to total.

Make sure each group has the same number of rows, or adjust the formula manually for groups that are different sizes. You can always click on a cell and edit the formula in the formula bar if a group needs a different range.

Frequently Asked Questions

Why does my total show a time like 3:45 when I expected 27:45?

Excel's standard time format treats 24 hours as a full day and rolls over to the next day. So 27 hours 45 minutes displays as 3:45 (the remainder after one full day). To see the full hour count, right-click the cell, choose Format Cells, select Time, and use the format [h]:mm instead of the standard format.

Can I add times that are in different formats, like some as 2:30 and some as 2.5?

Yes. Excel recognizes both formats as time values and adds them correctly. However, the result will display in whatever format the cell is set to. If you mix formats in your original data, format your total cell as time (hours:minutes) to keep the display consistent.

What if I need to add hours from multiple columns, not just one?

Use a formula like =SUM(B2:B10,D2:D10,F2:F10) to add ranges from different columns. Separate each range with a comma. Excel will add all the values together regardless of which columns they are in.

How do I subtract hours instead of adding them?

Replace SUM with a subtraction formula. For example, =B2-B3 subtracts the time in B3 from the time in B2. If you need to subtract multiple values, you can type =B2-B3-B4-B5 or use a formula like =B2-SUM(B3:B5) to subtract a group of times from a starting time.

Why does my formula show an error like #VALUE!?

This usually means one of the cells in your range contains text or a value that is not formatted as time. Check each cell in your formula range to make sure it contains only a time value, not a label or note. Delete any non-time content and the formula should work.