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

Get FREE Advanced Excel Exercises with Solutions!

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.

Sample dataset to show How to Add 8 Hours to Time in Excel

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 

Divide Hour Value by 24 and Add It

  • Now, as usual, drag down the fill handle to accomplish the job.

Divide Hour Value by 24 and Add It

  • So, after adding 8 hours to determine the last working hours, this is the final table.

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.

Use TIME Function to Add 8 Hours

  • After dragging down the series, the final table will look like this.

Use TIME Function to Add 8 Hours

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


Similar Readings


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")

Apply TIMEVALUE Function

  • The final table will look like this after dragging down the fill handle.

Apply TIMEVALUE Function

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.

enter the formula

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.

enter the formula

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.


Related Articles

Al Ikram Amit

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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo