Converting json date time format

[android1]

Hi,

I have a column full of json dates & times like this-> /Date(1457355600000). I need to convert this to 07/03/2016 1:00PM
but am a bit bamboozled.

 

[dave3009]

Hi, that is milliseconds since the turn of the day 1/1/1970 GMT, so (assuming the json time in A2)....

=(A2/86400000)+25569

Would return the time 0 from GMT, you can convert it to your timezone but appending the time difference

Excel 2007
	A	B
2	1457355600000	07/03/2016 13:00:00
Sheet4

Cell Formulas
Range	Formula
B2	=(A2/86400000)+25569

=(A2/86400000)+25569+(-6/24)

Is 6 hours behind GMT

HTH

 

[android1]

Thanks a million dave. Any idea why I'd be getting my years as 1984 instead of 2016?

 

[dave3009]

Thanks a million dave. Any idea why I'd be getting my years as 1984 instead of 2016?

That seems odd, I was only able to test the one actual json date you posted, could you post a set of say 10-15 more. Even better if you can use a HTML Table maker (such as the one in my signature block) to show what json dates you have and the erroneous results.

Thanks