Hi,
After downloading the data, I am not able to see the date/ time of each entry. It is coded into "1.43562E+12". How do I go about fixing this format?
Created by Aparna Suresh aparnasuresh https://www.google.com/search?q=convert+epoch+to+date+in+excel
But remember, you have 13 digit *millisecond* epochs, not 10 digit *second* epochs, so you have to divide by 1000. How do I convert that to the date and time that I can see on the portal? It shows up clearly on this site, but it is converted to the 13 digit number in excel. Hi, the time stamps are encoded as [unix epochs](https://en.wikipedia.org/wiki/Unix_time#Encoding_time_as_a_number), 13 digit numbers in *milliseconds*. ^ For the MyHeartCounts data