DateAdd function in VBA

[Sake14]

Hello to all,

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!!

 

[diddi]

in the vba window, when you step the code, you can hover over the variables and their values will be displayed as the code is executed
it can be handy when you cant see whats going on in a sub

 

[Sake14]

in the vba window, when you step the code, you can hover over the variables and their values will be displayed as the code is executed
it can be handy when you cant see whats going on in a sub

Thanks a lot!