I am trying to add five hours to my date and time. I have together the time and date data in a cell in excel format.

I want to add five hours at each one of them and I am using the next formula but nothing happens ("H" is the column in which I have the Date and Time)

Any help please because I have to deliver that by tonight for my job:

Sub ForNextLoop()

Dim x As Integer

For x = 2 To Cells(2, "H").End(xlDown).Row - 1

Cells(x, "H") = DateAdd("h", 5, Cells(x, "H"))

Next

End Sub

Thanks a lot!!