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.
|
||||||
Excel & Unix Timestamps |
||||||
|
Copyright © 2010 Nickapedia - All Rights Reserved 7 guests, 1 members Max visitors today: 15 at 05:10 am MST This month: 22 at 03-01-2010 11:23 am MST This year: 93 at 02-05-2010 07:48 am MST All time: 93 at 02-05-2010 07:48 am MST |
||||||