7
2
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?
2+1: I prefer (timestamp / 86400 + 25569) but they're the same thing. Format the field as date/time and you're good to go. – Satanicpuppy – 2011-03-02T15:06:21.073
& @Satanicpuppy: +1 - Confirmed both methods work and produce identical results using the Unix Time entry at Wikipedia. Properly implemented, the formulas should translate 1299098490 to 03/02/2011 @ 20:41:30 Zulu after formatting the cell to date/time. – Iszi – 2011-03-03T02:26:02.473
Only works if your locale is set to "DD/MM/YYYY", whereas other people have it as "YYYY/MM/DD", then you have to use the localized date format. Rather use
DATE(1970,1,1)
– David d C e Freitas – 2013-02-13T10:10:58.047