I have a epoch time in cell
H2 which has a value of
1517335200000. I am trying to convert it to a human readable format which should return
30/01/2018 6:00:00 PM in GMT.
I have tried to convert it with the formula
H2/86400+25569 which I got from the OpenOffice forum. The formula returns the value
17587319. When I change the number format in LibreOffice Calc to
Date, it returns the value of
06/09/-15484. That's not the value I want. So, how can I get the value in dd/mm/yyyy hh:mm:ss format form?