View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily
 
Posts: n/a
Default Convert Unix timestamp to Readable Date/time

Are there any Excel functions available to convert Unix time (seconds since
1/1/1970) to a readable date/tiem? Or does anyone know of a calculation I
can do to convert this type of data to a date/time that is more usable?

I can find converters on the web, but I need a function or macros within
excel.

Thanks