# How to Add 1 Hour to Time in Excel (7 Examples)

Often, we need to add hours to time in Excel. The task is quite simple, handy, and easy to understand. If you want to add hours to time in Excel easily, then you can follow this article to learn various ways to do this job. In this article, I will show you seven suitable examples to add 1 hour to time in Excel. So, read the article carefully in order to get an idea for various scenarios and save time.

## How to Add 1 Hour to Time in Excel: 7 Suitable Examples

However, you can add 1Â  hour to time in Excel manually or by using various formulas. For the purpose of demonstration, I have used the following sample dataset to provide you with a better idea about the operation. Hence, I have selected some products which need to be delivered within 1 hour and I will show the order time and delivery time in this regard. Using this dataset, I will illustrate the ways to add 1 hour to time in Excel easily.

### 1. Applying Conventional Formula

In general, it is one of the easiest methods to add 1 hour to time in Excel. You may use this quick and easy formula in Excel to add 1 hour to a specific time value. However, you will need to supply the Order Time from a particular cell and 1 hour that you want to add with the given time which is divided by 24.

📌Â  Steps:

• First, enter the following formula in Cell D5.

`=C5+(1/24)`

• Next, press the Enter key and use the AutoFill tool to apply the formula to the entire column.

• Finally, the output will appear in the following image.

### 2. Using TIME Function

Also, you can use the TIME function to add 1 hour to time in Excel. Moreover, you can easily change hours, minutes, and seconds with this function. In this part, I will show you some steps so that you can complete the task properly.

📌Â  Steps:

• Initially, write the following formula in Cell D5 and press Enter.

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

• Then, utilize the AutoFill tool to complete the task for the whole column.

### 3. Combining TIME and MOD Functions

Apart from the second example, you can add hours to the time by combining the TIME and MOD functions. However, go through the following steps in order to add 1 hour to time in Excel.

📌Â  Steps:

• First, write the following formula in Cell D5 and hit the EnterÂ button.

`=TIME(MOD(1,24),0,0)+C5`

Formula Breakdown

• First, MOD(1,24) returns the value 1.
• Then, TIME(MOD(1,24),0,0) function takes the output of the previous function as the main text and returns 1:00 as the time format.
• Finally, TIME(MOD(1,24),0,0)+C5 function returns the final output.
• Next, apply the formula to the complete column by using the AutoFillÂ tool.

• Finally, you will get the output as in the below image.

### 4. Adding 1 Hour to Time for a List of Date Time

In addition, you can add 1 hour to time for a list of dates and times. The process is quite similar. Here, I have the date and time combinations in the Order Time column and with these times I will add up to 1 hour to get the Delivery Times. Hence, go through the steps below.

📌Â  Steps:

• Firstly, write down the following formula in Cell D5 and hit Enter.

`=C5+(1/24)`

• Now, you can use the AutoFill tool to get the result for the whole column.

• Lastly, the output will be as follows.

### 5. Adding 1 Hour to Time for Less Than 24 Hours

For example, I will normally add the Order Time with the time 1 hour to get the Delivery Time of the products, 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 the Time format like below.

📌Â  Steps:

• First of all, insert the following formula in Cell D5 and hit Enter.

`=C5+(1/24)`

• Secondly, utilize the AutoFill tool to complete the column.

• Finally, you will get the final result.

### 6. Adding 1 Hour to Time Over 24 Hours

In this part, I will add the Order Time with the time 1 hour to get the Delivery Time of the products. But here the final results after summing up will be over 24 hours. For this reason, I have changed the order time as in the following image.

📌Â  Steps:

• First, write down the following formula in Cell D5 and press the EnterÂ key.

`=C5+(1/24)`

• After that, complete the column using the AutoFillÂ tool.

• Finally, the final result will appear below.

### 7. Embedding VBA Code

Excel VBA is a rich tool to perform multiple operations in sheets. Fortunately, a VBA code can also help you to add 1 hour to time in Excel. So, a VBA code is necessary for this method. I have changed the dataset a little bit in this regard. However, you can just copy the code and run it in your Excel worksheet by following the below steps.

📌Â  Steps:

• First, press the Alt+F11 keys in Excel and open the Microsoft Visual Basic ApplicationsÂ window.
• Next, click the Insert button and click on Module from the menu to create a module.

• After that, a new window will open. Write the following VBA macro in the ModuleÂ window.
``````Function Houraddition(value As String, x As Integer) As String
'ExcelDemy Publications
Dim dt1 As Date
dt1 = CDate(value)
Houraddition = Format(dt1, "m/d/yy hh:mm AM/PM")
End Function``````

• This code will create the function Houraddition.
• Fourthly, select Cell D5 and hit the EnterÂ button.

`=Houraddition(C5,D5)`

• Now, applying the AutoFill tool you can apply the formula to the entire column.

• Finally, the final result will appear in the following picture.

## 💬 Things to Remember

• For the purpose of demonstration, I have used Microsoft Excel 365 version here, you can use any other version according to your convenience.
• If you want to get proper output, keep the Time as Number Format.
• You can use any cell instead of D5 according to your choice.
• Fortunately, you can apply the VBA code to any worksheet and generate the function.

## Conclusion

These are all the steps you can follow to add 1 hour to time in Excel. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

## Related Articles

<< Go Back to Add Time in Excel | Calculate TimeÂ | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF