How to add time in Excel

Excel treats time as a decimal fraction of a 24-hour day, so adding time works the same way as adding any other number. If you want to add 2 hours to a time that's already in a cell, you can use a formula like =A1+TIME(2,0,0), where A1 contains your starting time. The TIME function takes three arguments in order: hours, minutes, and seconds.

You can also add time by converting hours, minutes, or seconds to their decimal equivalents. For example, 30 minutes equals 0.5 in Excel's time system (since 30 minutes is half of 60), so =A1+0.5 adds 30 minutes to the time in cell A1. This works because Excel stores time as a fraction of 24 hours: one hour is 1/24, or about 0.0417.

The most readable approach for most people is the TIME function, because it's clear what you're adding. If you're adding multiple time values together — say, three separate durations in cells A1, A2, and A3 — you can write =A1+A2+A3 and Excel will sum them as long as they're all formatted as time.

Key Takeaways

  • Use the TIME function with the format =TIME(hours, minutes, seconds) to add a specific duration to a time in a cell.
  • Excel stores time as a decimal where 1 hour equals approximately 0.0417 and 1 minute equals approximately 0.000694, so you can add these decimals directly to a cell containing time.
  • When adding multiple time values together, simply use the plus sign between cell references, such as =A1+A2+A3.
  • If your result shows as a decimal instead of a time format, right-click the cell, select Format Cells, and choose a time format from the list.

Using the TIME function for specific durations

The TIME function is the clearest way to add a known duration to an existing time. Open your spreadsheet and click on the cell where you want the result to appear. Type =A1+TIME(2,30,45) to add 2 hours, 30 minutes, and 45 seconds to whatever time is in cell A1. You can adjust the three numbers to match what you need to add.

This method works well when you're adding the same duration repeatedly. If you need to add 8 hours to a column of clock-in times, you can write the formula once in the first result cell, then copy it down to all the other rows. Excel will automatically adjust the cell reference (A1 becomes A2, A3, and so on) while keeping the TIME function the same.

Adding time by converting to decimal hours or minutes

If you prefer working with decimals, you can convert any duration to its decimal equivalent and add it directly. Divide minutes by 60 to get the decimal: 15 minutes becomes 0.25, 30 minutes becomes 0.5, and 45 minutes becomes 0.75. For seconds, divide by 3600 (the number of seconds in an hour).

So if you want to add 1 hour and 15 minutes to a time in cell A1, you would write =A1+1.25. This is faster to type than the TIME function if you're working with simple durations, but it's less obvious what the number means when you look at the formula later. For a spreadsheet you'll share with others or come back to months from now, TIME is usually the better choice.

Fixing time format when results show as decimals

After you add time, Excel sometimes displays the result as a decimal like 0.583333 instead of showing it as a time like 2:00 PM. This happens because the cell is formatted as a number rather than as time. The calculation is correct — Excel just isn't displaying it the way you want.

Right-click on the cell containing the result and select Format Cells. In the window that opens, click the Number tab (if it's not already selected), then find and click Time in the Category list on the left. You'll see several time format options in the middle column — pick the one that matches how you want the time to look, such as 1:30:55 PM or 13:30:55. Click OK and your result will display as a proper time.

Adding time across multiple cells

If you have several time durations in different cells and want to add them all together, use the SUM function. Click on the cell where you want the total, then type =SUM(A1:A5) to add all the times from A1 through A5. This is faster than writing =A1+A2+A3+A4+A5, especially when you have many cells to add.

Make sure all the cells you're summing are formatted as time, not as text or numbers. If one cell contains text that looks like a time (for example, if you typed "2:30" as text instead of letting Excel recognize it as time), SUM will ignore that cell. You can check by clicking on a cell and looking at the formula bar at the top — if it shows an apostrophe before the time, like '2:30, then it's stored as text and won't be included in your sum.

Working with time that crosses midnight

If you add time and the result goes past 24 hours (midnight), Excel wraps it back to the beginning of the day. For example, if you add 5 hours to 11:00 PM, you get 4:00 AM the next day — but Excel displays only 4:00 AM, not the date. This is usually fine for calculating work hours or durations, but it can be confusing if you're tracking actual clock times across multiple days.

If you need to show that time has crossed into the next day, you can use a formula that calculates the number of full days separately. For most everyday tasks — adding hours to a shift start time, calculating total work hours, or combining time durations — the standard TIME function works without any adjustment. Just be aware that if your result is larger than 24 hours, you'll see only the remainder after dividing by 24.

Frequently Asked Questions

Why does my time formula show a decimal instead of a time?

The cell is formatted as a number instead of time. Right-click the cell, select Format Cells, choose Time from the Category list, pick a time format, and click OK. The calculation is correct — Excel just needs to be told how to display it.

Can I add time if it's stored as text?

Not directly. If a cell contains time as text (you'll see an apostrophe in the formula bar), Excel won't recognize it as a number. You can convert it by using the TIMEVALUE function: =TIMEVALUE(A1)+TIME(1,0,0) converts the text in A1 to time, then adds 1 hour. After that, format the result as time.

How do I add hours and minutes without using the TIME function?

Convert to decimals: 1 hour and 30 minutes becomes 1.5 (since 30 minutes is 0.5 hours). So =A1+1.5 adds 1 hour and 30 minutes to the time in A1. Divide minutes by 60 to get the decimal: 45 minutes is 0.75, 20 minutes is 0.333, and so on.

What if I want to add time and show the total number of hours worked?

Use SUM to add all your time cells, then format the result as time. If the total is more than 24 hours and you want to see the full count (like 35:30 for 35 hours and 30 minutes), right-click the cell, select Format Cells, choose Time, and pick the format that shows [h]:mm:ss — the brackets tell Excel to display hours beyond 24.

Can I add time to a date and time together?

Yes. If cell A1 contains both a date and time (like 3/15/2024 2:30 PM), you can add time to it the same way: =A1+TIME(3,0,0) adds 3 hours. Excel treats the date and time as a single number, so adding time works automatically without any special steps.