Excel can add hours, minutes, and seconds together, but the process depends on how your time data is formatted

If your time values are stored as actual time (not text), Excel treats them like any other number. One hour equals 1/24 of a day in Excel's internal math. To add times, you use the same SUM function you would use for regular numbers, or you can use a formula like =A1+B1 to add two cells together. The result will display as a time value if you format the cell correctly.

The catch: if your times are stored as text — which happens when you copy times from email, PDFs, or certain websites — Excel won't recognize them as numbers and the addition won't work. You'll need to convert them first, or use a different approach.

Key Takeaways

  • Use =SUM(A1:A5) to add multiple time cells, or =A1+B1 to add two cells together, as long as the times are formatted as actual time values, not text.
  • If your result shows as a decimal (like 0.5) instead of a time (like 12:00), right-click the cell, select Format Cells, and choose Time from the Category list.
  • Times stored as text will not add correctly; you can check by clicking a cell and looking at the formula bar to see if it starts with an apostrophe (').
  • If you need to add times that cross midnight or span multiple days, use the formula =MOD(SUM(A1:A5),1) to keep the result within a 24-hour display.

Setting up your time data so Excel recognizes it

Before you add times, make sure Excel knows they are times and not text. Click on a cell that contains a time value. Look at the formula bar at the top — if the time appears with an apostrophe before it (like '14:30), it is stored as text and Excel will not add it.

If your times are formatted correctly, the formula bar will show just the time with no apostrophe. You can also check the cell alignment: text aligns to the left by default, while time values align to the right. If all your times are left-aligned, they are probably text and need to be converted.

To convert text times to real times, select the column, go to the Data menu, click Text to Columns, click Next twice, and then click Finish. This forces Excel to re-read the values as times instead of text.

Using SUM to add multiple time cells

The simplest way to add times is the SUM function. If you have times in cells A1 through A5, type =SUM(A1:A5) in an empty cell below them. Press Enter, and Excel will add all five times together.

SUM works the same way whether you are adding two times or twenty. You can also use it with non-consecutive cells: =SUM(A1,A3,A5) will add only those three cells and skip A2 and A4.

The result will appear as a decimal (like 0.625) until you format it as time. Right-click the cell with your result, select Format Cells, click the Number tab, choose Time from the Category list on the left, and pick a time format from the list. Now your result will display as hours and minutes instead of a decimal.

Adding two time cells with a straightforward formula

If you only need to add two times, you can use a basic addition formula: =A1+B1. This works exactly like SUM but is faster to type when you are combining just two values.

You can also subtract times this way: =A1-B1 will show how much time elapsed between two moments. For example, if A1 is 14:30 (2:30 PM) and B1 is 09:00 (9:00 AM), the result will be 5:30 (five and a half hours).

Handling times that add up to more than 24 hours

If you are adding work hours across multiple days, your total might be more than 24 hours. For example, if you add 10 hours + 8 hours + 9 hours, the total is 27 hours. Excel will display this as 3:00 (showing only the hours past 24) unless you format it differently.

To display times that exceed 24 hours correctly, right-click the cell with your sum, select Format Cells, click the Number tab, and choose Time from the Category. In the Type list, look for a format that starts with [h]:mm (with square brackets). The brackets tell Excel to count hours beyond 24 instead of resetting at midnight. Now 27 hours will display as 27:00 instead of 3:00.

If your times are already added and displaying wrong, you can also use the formula =MOD(SUM(A1:A5),1) to keep the result within a 24-hour cycle, or remove the MOD function entirely if you want to see the full hour count.

Converting decimal results back to time format

Sometimes Excel shows your time sum as a decimal like 0.625 or 1.333. This happens when the cell is formatted as a number instead of time. The decimal is correct — 0.625 represents 15 hours (0.625 × 24 = 15) — but it is not readable as time.

To fix this, right-click the cell, select Format Cells, click the Number tab, choose Time from the Category list, and select a format. The most common choice is 13:30:55 (hours, minutes, seconds) or 13:30 (hours and minutes only). Click OK, and your decimal will convert to a readable time.

If you want to see both the decimal and the time, you can create a second formula in another cell using the same SUM or addition formula, then format only that new cell as time. This way you have both versions if you need them.

Troubleshooting when times won't add

If your formula returns an error or a wrong result, the most common cause is that your times are stored as text. Check the formula bar: if you see an apostrophe before the time, it is text. Use Data > Text to Columns to convert it, then try your formula again.

Another common issue is mixing time formats. If some cells show time as 14:30 and others show it as 2:30 PM, Excel may not recognize them all as the same type. Select all your time cells, right-click, choose Format Cells, and explore the same time format to all of them.

If your formula shows a result like 0.5 but you expected a time, the cell is formatted as a number. Format it as time using the steps above. If your result shows as ##### (a row of hash marks), the column is too narrow to display the result. Double-click the border between the column headers to auto-fit the width.

Frequently Asked Questions

Can I add times that are in different formats, like some showing 14:30 and others showing 2:30 PM?

Yes, as long as they are both stored as time values (not text), Excel will add them correctly regardless of how they display. However, for clarity, format all your times the same way before you add them. Select all the time cells, right-click, choose Format Cells, and pick one format for the entire column.

What if I need to add hours and minutes separately, like 5 hours and 30 minutes?

Enter them in separate cells and add them together: put 5:00 in one cell and 0:30 in another, then use =A1+B1. The result will be 5:30. Alternatively, you can type the total directly as 5:30 in a single cell if you know the combined value.

How do I add time if some of my data is in hours as a decimal, like 5.5 for five and a half hours?

Multiply the decimal by 1 to convert it to Excel's time format: =5.5/24 gives you 5 hours and 30 minutes. Then add that result to your other times. Or convert the decimal column using a formula like =A1/24 in a new column, then add the new column together.

Why does my time sum show as a negative number or a very large decimal?

This usually means the cell is formatted as a number instead of time. Right-click the cell, select Format Cells, choose Time from the Category, and pick a format. The display will correct itself. If the value is still wrong after formatting, check that your original time values are stored as times, not text.