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.
- First, enter the following formula in Cell D5.
- 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.
Read More: Add 8 Hours to Time in Excel
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.
- Initially, write the following formula in Cell D5 and press Enter.
- Then, utilize the AutoFill tool to complete the task for the whole column.
- Finally, you will receive your desired output.
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.
- First, write the following formula in Cell D5 and hit the Enter button.
- 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.
- Firstly, write down the following formula in Cell D5 and hit Enter.
- 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.
- First of all, insert the following formula in Cell D5 and hit Enter.
- Secondly, utilize the AutoFill tool to complete the column.
- Finally, you will get the final result.
Read More: How to Add 30 Minutes to Time in Excel
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.
- First, write down the following formula in Cell D5 and press the Enter key.
- After that, complete the column using the AutoFill tool.
- Finally, the final result will appear below.
Read More: How to Add Time in Excel Over 24 Hours
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.
- 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) dt1 = DateAdd("h", x, dt1) 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.
- Now, applying the AutoFill tool you can apply the formula to the entire column.
- Finally, the final result will appear in the following picture.
Read More: How to Add Hours and Minutes in Excel
💬 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.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
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.