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

A dataset from the production of textiles is shown in the picture below. We’ll add 8 hours to the order time to get the Delivery time.

Method 1 – Divide Hour Value by 24 and Add It

Steps:

Choose a blank cell, such as F5, and insert the following formula into the formula bar, then press the Enter key.

=D5+E5/24

Drag down the fill handle.

This is the final table.

Method 2 – Use the TIME Function to Add 8 Hours

Steps:

Go to cell E5 and apply the following formula.

=D5+TIME(8,0,0)

Hit the Enter key.

Drag down the fill handle for the series.

Method 3 – Apply the TIMEVALUE Function

Steps:

Use the following formula in E5.

=D5+TIMEVALUE("8:0:0")

Hit Enter and drag down the fill handle.

Method 4 – Apply VBA Code

Steps:

Press Alt + F11, and a VBA window will appear.

Navigate to the Insert Tab and open a new Module.
Insert 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. We’ll give this date-time the format we want.