Convert epoch time to readable time in excel [duplicate]

Question

I have a excel sheet where in column (G) there is a timestamp but is in epoch format, how can i convert epoch time to readable time format in excel.

I have already tried =TEXT(G2,"DD/MM/YYY HH:MM:SS") but it didn't work.

Answer 1

Try this:

=TEXT((G2/1000 + ("1/1/1970"-"1/1/1900"+1)*86400) / 86400,"DD/MM/YYYY HH:MM:SS")