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.


Add 8 Hours to Time in Excel: 4 Simple Ways

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


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.

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


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

Apply TIMEVALUE Function

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

Apply TIMEVALUE Function


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.

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 


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


<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo