P Pete_UK Dec 22, 2009 #2 Take a look at John McGimpsey's site: http://www.mcgimpsey.com/excel/udfs/unixtoxltime.html Hope this helps. Pete
Take a look at John McGimpsey's site: http://www.mcgimpsey.com/excel/udfs/unixtoxltime.html Hope this helps. Pete
R Ron Rosenfeld Dec 22, 2009 #3 how do i convert unix epoch seconds to yyyy:mm:dd in excel Click to expand... unix epoch seconds (UES) = number of seconds since 1 jan 1970 Excel stores time as days + fractions of a day. Number of seconds in a day = 60*60*24 = 86400 So to convert: UES/86400 + date(1970,1,1) and format as yyyy:mm:dd --ron
how do i convert unix epoch seconds to yyyy:mm:dd in excel Click to expand... unix epoch seconds (UES) = number of seconds since 1 jan 1970 Excel stores time as days + fractions of a day. Number of seconds in a day = 60*60*24 = 86400 So to convert: UES/86400 + date(1970,1,1) and format as yyyy:mm:dd --ron