This gets the number of years assuming that value is in A1

=DATEDIF(--"1970-01-01",--"1970-01-01"+A1/24/60/60,"Y")

How do you want the answer?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"--== Alain ==--" wrote in message
...
Hi,

i've got some exported log from unix platform.
in those logs, time and date is written as lapsed second since 01.01.1970.

How can i extract date and time from this lapsed second since 01.01.1970.

e.g : 1165391099.763

thanks a lot,

Al.