Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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 knowing 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.


Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.


7 Suitable Examples to Add 1 Hour to Time in Excel

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.

Sample Dataset for How to Add 1 Hour to Time in Excel


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:

  • Firstly, enter the following formula in Cell D5.

=C5+(1/24)

How to Add 1 Hour to Time in Excel by Applying Conventional Formula

  • Secondly, 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 (4 Suitable Ways)


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)

Using TIME Function to Add 1 Hour to Time in Excel

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

  • Finally, you will receive your desired output.

Read More: How to Add Hours, Minutes, and Seconds in Excel


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:

  • At first, write the following formula in Cell D5 and hit the Enter button.

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

Combining TIME and MOD Functions to Add 1 Hour to Time in Excel

Formula Breakdown

  • Firstly, 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.
  • Secondly, apply the formula to the complete column by using the AutoFill tool.

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

Read More: How to Add Time in Excel Automatically (5 Easy Ways)


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)

Adding 1 Hour to Time for a List of Date Time

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

  • Lastly, the output will be as follows.

Read More: How to Add Time to Date in Excel (4 Useful Methods)


Similar Readings


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)

How to Add 1 Hour to Time for Less Than 24 Hours

  • 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 (3 Easy Methods)


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.

Sample Dataset for Adding 1 Hour to Time Over 24 Hours

📌  Steps:

  • At first, write down the following formula in Cell D5 and press the Enter key.

=C5+(1/24)

How to Add 1 Hour to Time Over 24 Hours

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

  • Lastly, the final result will appear below.

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


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.

Embedding VBA Code to Add 1 Hour to Time in Excel

📌  Steps:

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

  • Thirdly, 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

VBA Code to Add 1 Hour to Time in Excel

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

=Houraddition(C5,D5)

Using Houraddition Formula to Add 1 Hour to Time in Excel

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

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

Read More: Adding Hours and Minutes in Excel (4 Suitable Methods)


💬 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.

For more information like this, visit ExcelDemy.com.


Related Articles

Mehedi Hasan

Mehedi Hasan

Hi, I am Mehedi. I have completed my B.Sc. from Bangladesh University of Engineering and Technology. I have a strong interest in innovation and research in the field of Data Science and Machine Learning. Gradually, I now understand the value of Data Analysis and I am trying to learn everyday.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo