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.
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.
Bookmarks