30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / How to Add Hours into Time in Excel
By Puneet Gogia (Microsoft MVP)

How to Add Hours into Time in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

To add hours to a time, divide the hours by 24 and add: =A1+(3/24) adds three hours. The TIME function does it without the arithmetic: =A1+TIME(3,0,0).

To subtract, use a minus sign. Two things to watch.

If the total passes midnight, plain addition rolls into the next day and displays only the time part — use =MOD(A1+(3/24),1) to wrap it, or format as [h]:mm if you want to see the full elapsed total past 24 hours.

And TIME’s hour argument caps at 32767 and rolls over above 23, so TIME(25,0,0) gives 1:00 AM rather than 25 hours — for large hour values the division method is the reliable one.

To add an hour value into a time value in Excel, you can use a simple and short formula where you need to specify the original time from a cell and the hour(s) value that you want to add after dividing it by 24 (which is the total number of hours in a day). The following example shows a time value in cell A1 (12:01 AM), and here you need to add 3 hours.

cell-with-time-value
Add Hours Into Time / Excel Formula

Formula to Add Hours in a Time

Here are the steps that you can use to add hours to a time:

  1. First, refer to the cell where you have the time value (A1 in our example).
  2. After that, enter the plus operator (+) and type an opening parenthesis.
  3. Next, enter the hour value you want to add to the original time.
  4. Now, enter a division operator and type 24, the total number of hours in a day.
  5. Finally, type a closing parenthesis and hit Enter to get the result value.
formula-to-add-hours
=A1+(3/24)

The formula is quite simple. You specify the original time and then add the hour value divided by 24. For 12:01 AM, it returns 3:01 AM.

Use Time Function to Add Time

You can also use the TIME function to add hours to a time value. You can see this in the following formula.

time-function-to-add-time

You need to specify the original time, use the TIME function, and only specify the hour argument with the hours you want to add (and 0 for minutes and seconds).

=A1+TIME(3,0,0)

With TIME, you can also add hours and minutes together. For example, =A1+TIME(3,30,0) adds three and a half hours.

But TIME can’t add 24 hours or more: its hour argument starts again after 23, so TIME(25,0,0) is the same as 1:00 AM. For more than 24 hours, use the division formula (like =A1+30/24) instead.

time-function-with-hour-argument

Add Hours from Another Cell

If the number of hours is in a cell (B1), divide that cell by 24. You can then drag the formula down for a whole list:

=A1+B1/24

When the Result Goes Past Midnight

If you add 3 hours to 10:00 PM, the result is 1:00 AM of the next day. The cell holds 1.0417 (one day and one hour), and with a time format, you see only 1:00 AM. To keep only the time part, wrap the formula in MOD:

=MOD(A1+(3/24),1)

And if the cell has a date and time, the same formula =A1+(3/24) also moves the date forward when it passes midnight.

Subtract Hours from a Time

To subtract hours, use the minus operator. If the result goes before midnight, Excel can’t show a negative time and shows ####, so use MOD here as well (12:01 AM minus 3 hours returns 9:01 PM):

=MOD(A1-(3/24),1)

Frequently Asked Questions

Why does my result show as a decimal number?

The result cell has the General format. Apply a time format like h:mm AM/PM to the cell.

Why do I get ##### after subtracting hours?

The result is a negative time, which Excel can’t show. Use the MOD formula shown above.

How do I add hours to a total of more than 24 hours?

Use the division formula and apply the custom format [h]:mm to the cell, so the hours keep counting past 24.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment