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