If you want to add hours to time in Excel easily, then you can follow this article for knowing various ways to do this job. So, letâ€™s get into the main article for exploring those ways.

**Table of Contents**hide

## Download Workbook

## 8 Ways to Add Hours to Time in Excel

Here, we have the following two datasets; one is for the *Entry Time*, working *Time Period *of the employees of a company and the other is containing the records of the *Order Time*, *Duration *between the order time, and delivery time of the products of another company.

Using these datasets, we will illustrate the ways to add hours to time in Excel easily.

We have used *Microsoft Excel 365* version here, you can use any other versions according to your convenience.

__Method-1__: Add Hours to Time in Excel for Less than 24 Hours

Here, we will normally add the *Entry Time *with the *Time Period *to get the *Exit Time *of the employees, and here the results after summing up will be less than 24 hours so no extra step will be needed here.

For adding up the times simply with the addition operator you have to keep both of the values in *Time *format like below.

** Steps**:

âž¤ Use the following formula in cell

**E5**.

`=C5+D5`

Here, **C5 **is the *Entry Time*, **D5 **is the *Time Period*.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

After adding up hours with the *Entry Times *we are getting the following *Exit Times*.

**Read More:** **Excel Formula for Overtime over 8 Hours (4 Examples)**

__Method-2__: Add Hours to Time in Excel for More than 24 Hours

To get the *Exit Times *more than 24 hours after adding up hours with the *Entry Times*, we have increased the hours of the *Time Periods *in this example.

** Steps**:

âž¤ Use the following formula in cell

**E5**.

`=C5+D5`

Here, **C5 **is the *Entry Time*, **D5 **is the *Time Period*.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

So, we can see that after adding up values we are not getting our expected *Exit Times* because for equal to or more than 24 hours Excel will consider 24 hours into a day and then show up only the left hours and minutes as results.

To solve this problem select the *Exit Times *and then go to **Home **Tab >> **Number Format **dialog box symbol.

You can go there also by clicking **CTRL+1**.

Then the **Format Cells **dialog box will pop up.

âž¤ Go to **Number **Option >> **Custom **Option >> write **[h]:mm **in the **Type **box >> press **OK**.

Afterward, we will get our real added values for more than 24 hours.

**Read More:** **How to Add Time in Excel Over 24 Hours (4 ways)**

__Method-3__: Add Hours to Time in Excel Using the TIME Function

Here, we will use the **TIME function** to add up hours with the *Entry Times *to get the *Exit Times *and you can keep the hours of the *Time Periods *in **General **format here.

** Steps**:

âž¤ Type the following formula in cell

**E5**.

`=TIME(HOUR(C5)+D5,MINUTE(C5),SECOND(C5))`

Here, **C5 **is the *Entry Time*, **D5 **is the *Time Period*.

**HOUR(C5)+D5 â†’ 11+9****Output â†’**20

**MINUTE(C5) â†’ 30****SECOND(C5) â†’ 0****TIME(HOUR(C5)+D5,MINUTE(C5),SECOND(C5)) â†’**becomes**TIME(20,30,0)****Output â†’**20:30

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Finally, we are getting the *Exit Times *after adding up the hours of the *Time Periods *with the *Entry Times*.

__Method-4__: Add Hours to Time in Excel for Negative Hours

Suppose, we have some negative hours as *Time Periods *and here we will add these negative hours with the *Entry Times*.

*Though itâ€™s quite unusual to have a negative time period, we are showing through this dataset to maintain consistency and simplicity.*

** Steps**:

If we use the following formula like the previous method, then we will have

**#NUM!**error due to the negative results as time canâ€™t be negative.

`=TIME(HOUR(C5)+D5,MINUTE(C5),SECOND(C5))`

So, we will solve this problem by using the following formula

`=TIME(IF(HOUR(C5)+D5<0,24+HOUR(C5)+D5,HOUR(C5)+D5),MINUTE(C5),SECOND(C5))`

Here, **C5 **is the *Entry Time*, **D5 **is the *Time Period*.

**HOUR(C5)+D5<0 â†’ 11-9<0 â†’ 2<0****Output â†’**FALSE

**IF(FALSE,24+HOUR(C5)+D5, HOUR(C5)+D5) â†’**as it is FALSE so it will execute the 3rd argument**Output â†’**2

**TIME(IF(HOUR(C5)+D5<0,24+HOUR(C5)+D5,HOUR(C5)+D5),MINUTE(C5),SECOND(C5)) â†’ TIME(2,30,0)****Output â†’**2:30

** **

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Instead of getting **#NUM! **error, now, we are adding up to 24 to those negative values.

**Read More:** **How to Subtract and Display Negative Time in Excel (3 Methods)**

**Similar Readings:**

**How to Calculate Average Handling Time in Excel (2 Easy Ways)****Excel Timesheet Formula with Lunch Break (3 Examples)****[Fixed!] SUM Not Working with Time Values in Excel (5 Solutions)****How to Calculate Hours and Minutes for Payroll Excel (7 Easy Ways)****Excel Formula to Calculate Hours Worked Minus Lunch**

__Method-5__: Add Hours to Time in Excel for a List of Date Time

Here, we have the date and time combinations in the *Order Time *column and with these times we will add up the hours of the *Durations *to get the *Delivery Times*.

** Steps**:

If we use the following formula then instead of adding hours we will add the duration to the days,

`=C5+D5`

We can rectify that formula by dividing the hours of the *Durations *by **24 **for converting the day into hours. (1 day = 24 hours)

`=C5+D5/24`

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

As a result, we can successfully add the hours to the *Order Times *to get the *Delivery Times *(m-d-yy h: mm AM/PM) now.

**Read More:** **How to Subtract Date and Time in Excel (6 Easy Ways)**

__Method-6__: Using the TIME Function to Add Hours to Date Time

In this section, we will add hours to the *Order Times *by using the **TIME function**.

** Steps**:

âž¤ Type the following formula in cell

**E5**.

`=C5+TIME(D5,0,0)`

Here, **C5 **is the *Order Time*, **D5 **is the *Duration*. **TIME **will convert the duration into hours and then this hour will be added up with the *Order Time*.

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Eventually, we are getting the *Delivery Times *for the products.

**Read More:** **Calculate Elapsed Time Between Two Dates in Excel (5 Methods)**

__Method-7__: Combining TIME, MOD and INT Functions to Add Hours to Time

You can add up hours to the times by using the **TIME function**, **MOD function**, **INT function** also.

** Steps**:

âž¤ Type the following formula in cell

**E5**.

**=TIME(MOD(D5,24),0,0)+C5+INT(D5/24)**

Here, **C5 **is the *Order Time*, **D5 **is the *Duration*.

**MOD(D5,24) â†’ MOD(15,24)****Output â†’**15

**TIME(MOD(D5,24),0,0) â†’ TIME(15,0,0)****Output â†’**0.625

**INT(D5/24) â†’ INT(15/24) â†’ INT(0.625)****OutputÂ**0

**TIME(MOD(D5,24),0,0)+C5+INT(D5/24)**becomes**TIME(0.625+43474.2708333+0)****Output â†’**1-9-19 9:30 PM

âž¤ Press **ENTER **and drag down the **Fill Handle **tool.

Ultimately, you will get the *Delivery Times *for the products.

**Read More:**** Excel Formula To Calculate Time Worked**

__Method-8__: Using a VBA Code to Add Hours to Time in Excel

Here, we will use a **VBA** code to add up the *Duration *hours with the *Order Times *to get the *Delivery Times*.

** Steps**:

âž¤ Go to

**Developer**Tab >>

**Visual Basic**Option.

Then, the **Visual Basic Editor **will open up.

âž¤ Go to **Insert **Tab >> **Module **Option.

After that, a **Module** will be created.

âž¤ Write the following code

```
Function Houraddition(value As String, x As Integer) As String
Dim dt1 As Date
dt1 = CDate(value)
dt1 = DateAdd("h", x, dt1)
Houraddition = Format(dt1, "m/d/yy hh:mm AM/PM")
End Function
```

This code will create the function **Houraddition**, **CDATE** will convert the given value into date and **DATEADD** will add the hour value to this date. Finally, Â will give our desired format to this date-time.

Now, go back to the sheet and write the following formula in cell **E5**

`=Houraddition(C5,D5)`

Here, **C5 **is the *Order Time*, **D5 **is the *Duration* and **Houraddition **will add up the *Duration *to the *Order Date*.

âž¤ Press **ENTER **and drag down the **Fill** **Handle **tool.

In this way, we will get the *Delivery Times *for the products.

**Read More:** **How to Use Time Format in Excel VBA (Macro, UDF, and UserForm)**

## Practice Section

For doing practice by yourself we have provided the following **Practice** sections in the sheets named **Practice1 **and **Practice2**. Please do it by yourself.

## Conclusion

In this article, we tried to cover the ways to add hours to time in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.