Date Format

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

Your web browser must have JavaScript enabled in order for this application to display correctly.
If you are an automated web crawler from a search engine, follow this AJAX application crawl link

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?

Drop files to upload

Date Format page is loading…