epoch time conversion spread sheet

Here is the formula to convert epoch or unix time to human readable format.

when the data is in A1,

=(A1/86400)+25569+(+8/24)

The +8/24 is for the timezone correction as epoch time is in GMT.

http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/

Keywords: epoch unix time excel spread sheet conversion

blog comments powered by Disqus