MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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"