Help !! I'm stuck in time !! :)

[Guest]

Hi All,
Nope, I'm not a time traveller, but I do have something related to time
functions I can't get my head 'round.

I have to convert a timestamp to a humanly readable date/time.
The challenge is that the timestamp is an integer, and represents the amount
of seconds since 1/1/1970
1025538012 would be somewhere in mid 2002

Thing that bugs me is that I've seen this a couple of years ago, and
remember I was able to crack it then...must be getting old

Any pointers most welcome !

Take care,
Leo

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/unixtoxltime.html

 

[Frank Kabel]

Hi
try (if A1 stores your seconds)
=DATE(1970,1,1)+A1/(24*60*60)

 

[Guest]

Hi Frank,
Quite an "a-ha erlebnis"! That's exactly what I needed.

(I had to slightly modify to =date(1970;1;1) etc..but I guess that's
localization settings specific).

Sehr vielen dank,

Leo