excel formula to convert server time in seconds

  • Thread starter Thread starter frogman1001
  • Start date Start date
F

frogman1001

I extracted data from my server. It keeps a log of time like this
1069255091 (this morning)

I converted the data into excel but now I need this cell value to b
the actual date and time.

Any one have the easy answer
 
One way

=DATE(1970,1,1)+F1/86400

format result as

mm/dd/yy hh:mm:ss

or whatever your date format is, since I got 11/19/03 15:18:11

you might be in UK and change the date format accordingly
 
Back
Top