JSON to Date\Time format

[android1]

Hi,

I am trying to convert the following 13 digit json number -> 1452002465000 to date/time.

I am using this formula ->=D7/1000/86400. This is giving me 03/01/1946/ 12:28 PM.

The time is correct but the date is wrong (should be 05/01/2016)

 

[Special-K99]

According to this

javascript - Convert JSON Date /Date(1388624400000)/ to Date in Excel - Stack Overflow

the date is produced by extracting the first 10 digits
So...

=(LEFT(A1,10)/86400)+DATE(1970,1,1)