Hi all
In column D I have a list of values (seconds) which I want to add to an epoch time of 01/01/1900 00:00:00, i have tried inserting the epoch date into a cell then adding a column next to D and using the following to calculate the date/time and copy it down the column for all the values in D.

Sub i_startTime()
    Columns("E:E").Select
    Selection.insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    Selection.NumberFormat = "dd/mm/yyyy hh:mm:ss"
    Dim LR As Integer
    LR = Range("A" & Rows.Count).End(xlUp).Row
   Range("E1:E" & LR).Formula = "=R1C15+RC[-1]/86400"
 End Sub
This appears to work ok but when I cross check the results all the dates/time values in E are 2 days out.
I think I should be converting D into minutes then using something like DateAdd("m", value of D, "01/01/1900 00:00:00")

But not sure this would work or how to implement it.

Any advice would be greatly appreciated.