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.
Download Practice Workbook
You can download the practice workbook from the following download button.
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.
Read More: How to Add Time in Excel Automatically (5 Easy Ways)
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.
Read More: How to Add Hours, Minutes, and Seconds in Excel
Similar Readings
- How to Insert Current Date and Time in Excel (5 Easy Methods)
- Adding Hours and Minutes in Excel (4 Suitable Methods)
- How to Add 1 Hour to Time in Excel (7 Examples)
- Add 15 Minutes to Time in Excel (4 Easy Methods)
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.
Read More: How to Add Date and Time in Excel (4 Easy Methods)
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)
Xdate = DateAdd("h", p, Xdate)
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
-  DateAdd will add the hour value to the 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.
Read More: How to Add Time to Date in Excel (4 Useful Methods)
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.
Adding 30 Minutes:
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.
Adding More Than 24 Hours:
Select a blank cell, say D4, and then enter the formula =B4+C4/24 into the formula bar. As 1 day has 24 hours.
Read More: How to Add Time in Excel Over 24 Hours (4 ways)
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.