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.

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>