Epoch Date From Remedy

[mmcleod]

I am extracting data from a Remedy database and one of the fields is a date
expressed in seconds since 12:00 am, Jan1 1970 (approximately 1040688000).
Does anyone know if there is a way to convert these numbers to "regular"
dates?

Thanks

 

[mmcleod]

Cancel the question - I just figured it out.

 

[Norman Harker]

Hi mmcleod!

But why not share the solution?

=DATE(1970,1,1)+1040688000/(24*60*60)

Or a general solution not involving hard coding the formula:

=A1+B1/(24*60*60)

This way A1 can involve a time element as well as a date with an
assumed time of 12:00 midnight at the start of the day. And of course
B1 can be a complex calculation in its own right.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.