Converting Unix Time into Human Readable Format in Excel
I have a spreadsheet containing several timestamp columns, given in Unix time, i.e. number of seconds since 01/01/1970 00:00.00 UTC.
Using Excel 2010, are there any methods, and if so how, to convert these timestamps into a date/time format recognizable by Excel?
Try:
value / 86400 + "1/1/1970"
Division by 86400 is needed to convert it into days (product of 24 * 60 * 60), you then add the number of days between 1st Jan 1900 (which is where Excel bases its dates off) and 1st of Jan 1970.