View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
--== Alain ==-- --== Alain ==-- is offline
external usenet poster
 
Posts: 18
Default convert second to date and time

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.