=DATE(1970,1,1)+A1/24/60/60 and format as dd.mm.yyyy hh:mm:ss.000 (to show
as 06.12.2006 07:44:59.763) or however you want it displayed.
--
David Biddulph

"--== 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.