February 4, 2012

Excel & Unix Timestamps

How to convert Unix Timestamps to Date/Time in Excel.

=timestampcell / 86400 + 25569

Right click on the cell with the formula above Format Cell and choose Date or Time as the Format.