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

# Add 8 Hours to Time in Excel (4 Suitable Ways)

If you want to add hours accurately speaking work hours or 8 hours to time in Excel quickly, you may read this post to learn about numerous methods. So, let’s dive into the main article to look into those options.

## 4 Ways to Add 8 Hours to Time in Excel

A dataset from the production of textiles is shown in the picture below. In the following sections, we will discuss 4 quick methods to know the Delivery Time of various products within a short period. For example, in this method, we will utilize 8 hours as that short period.

### 1. Divide Hour Value by 24 and Add It

The first formula is simple, just dividing 8 hours by 24 and adding it with time. Let’s see.

📌 Steps:

• First, choose a blank cell, say F5, type the following formula into the formula bar, and then press the Enter key.
`=D5+E5/24 ` • Now, as usual, drag down the fill handle to accomplish the job. • So, after adding 8 hours to determine the last working hours, this is the final table. ### 2. Use TIME Function to Add 8 Hours

The TIME function in Excel converts a number in hours, minutes, and seconds format. Here we will use it to convert the value 8 to 8 hours. Then we will add this coveted value with preset times.

📌 Steps:

• Go to cell E5 and apply the following formula.
`=D5+TIME(8,0,0)`
• Hit the ENTER key. • After dragging down the series, the final table will look like this. ### 3. Apply TIMEVALUE Function

The TIMEVALUE Function belongs to the Excel Date/Time functions. The TIMEVALUE function allows us to transform a time from text to MS Excel time.

📌 Steps:

• If anyone needs to add time values, for example, in column E, you may use the below formula to compute new values in another column:
`=D5+TIMEVALUE("8:0:0")` • The final table will look like this after dragging down the fill handle. ### 4. Apply a VBA Code

To calculate the Delivery Times, we can also use a VBA code to add the Duration hours to the Order Times.

📌 Steps:

• First off, press Alt+F11, and a VBA window will appear.
• Now navigate to the Insert Tab >> and open a new Module.
• Write the following code in the module window:
``````Function Add_8Hours(val As String, p As Integer) As String
Dim Xdate As Date
Xdate = CDate(val)
Add_8Hours = Format(Xdate, "m/d/yy hh:mm AM/PM")
End Function``````
• This code will generate the function Add_8Hours.
• Cdate will convert the supplied value to a date
•  Finally, we’ll give this date-time the format we want.
• Now we will enter our manual function named Add_8Hours in F5. • After pressing Enter, we will get Delivery Time and then the final table, after dragging down the fill handle.

## How to Add 30 Minutes or Over 24 Hours to 8 Hours of Time in Excel

So far we have discussed how we can add 8 hours to any time in Excel. In this part, we will see how to add 30 minutes or over 24 hours to 8 hours of time.

Select a blank cell, say D4, and then enter the formula `=B4+C4/1440` into the formula bar. As, 1 hour= 60 mins, 1 day= 24hours that mean 24*60=1440. Select a blank cell, say D4, and then enter the formula =B4+C4/24 into the formula bar. As 1 day has 24 hours. ## Conclusion

We attempted to cover the methods for adding 8 hours to time in Excel in this article. I hope you find it beneficial. If you have any ideas or questions, please leave them in the comments area. And more such articles, visit our blog.

## Related Articles #### Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts 