Converting EPOCH timestamp

[AceFI]

hey all.

for some reason i just can't seem to convert a unix timestamp to correct date and time..
my raw timestamp is 1655186004.
www.epochconverter.com shows it as 17/6/2022 3:53:53 which is pretty much correct
i've tried formatting in excel using a few different ways from google...

F14 has the raw timestamp

=((F14/86400)/IF(LEN(F14)=13,1000,1))+DATE(1970,1,1) results in 14/06/22 5:53:24 am
=((F15/1000)/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1900")) results in 19/01/70 3:46:26 am
=(F15/86400)+DATE(1970,1,1) results in 14/06/22 5:53:24 am

any suggestions here?

thanks

 

[arthurbr]

Perhaps you mistyped using the converter?

 

[AceFI]

hey Arthur, by coincidence the time in the converter is actually correct

 

[AceFI]

hey team, another example that works in the website, but can't get to work in excel?? 1656314957352