E evangarich May 30, 2006 #1 I am trying to convert a unix timestamp to date and time in XL 2003. Any ideas? -Thanks
R Ron Rosenfeld May 30, 2006 #2 I am trying to convert a unix timestamp to date and time in XL 2003. Any ideas? -Thanks Click to expand... Unix time is merely the number of seconds since 01 Jan 1970 00:00 UTC Excel time is expressed in decimal days. There are 86,400 seconds in a day. So to convert a Unix timestamp to XL time =UnixTime/86400+DATE(1970,1,1) Format to something you like. Correct of the difference between UTC and your time zone if you want. --ron
I am trying to convert a unix timestamp to date and time in XL 2003. Any ideas? -Thanks Click to expand... Unix time is merely the number of seconds since 01 Jan 1970 00:00 UTC Excel time is expressed in decimal days. There are 86,400 seconds in a day. So to convert a Unix timestamp to XL time =UnixTime/86400+DATE(1970,1,1) Format to something you like. Correct of the difference between UTC and your time zone if you want. --ron
