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

bpeltzer wrote...
If your Unix time is in cell A1, then =A1/(24*60*60) + DATE(1970,1,1) should
convert it; you'll have to apply a Date/Time format to the result.
--Bruce
(BTW the division by 24*60*60 is because '1' represents a day in Excel.
Also, I've interpreted your post to mean that Unix time started at 12:00:00am
on 1/1/70).


Unix epoch time is supposed to be UTC (GMT), so time zone adjustment
may be needed as well.