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.
Add 8 Hours to Time in Excel: 4 Simple Ways
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 into 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 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)
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Â
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Â
Download Practice Workbook
You can download the practice workbook from the following download button.
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.
Related Articles
- How to Add Minutes and Seconds in Excel
- Add Milliseconds to Time in ExcelÂ
- How to Add Minutes to Time in ExcelÂ
- How to Add Hours to Time in ExcelÂ
- How to Add Hours and Minutes in ExcelÂ
- How to Add 1 Hour to Time in ExcelÂ
- Add 15 Minutes to Time in ExcelÂ
- How to Add Hours, Minutes, and Seconds in Excel
<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!