UNIX time conversion
Posted by Alan Robertson on August 07, 2001 7:19 AM
I get a report from a UNIX box with the time stated in seconds since Midnight, 1 Jan 1970, I hope someone has a formula that converts it into date and time.
Posted by Mark W. on August 07, 2001 7:40 AM
With your UNIX time is in cell A1 try using...
=A1/86400+"1/1/1970"
