Format of Distance and Time in Excel Export

[flashmason]

It seems that after my Export of my Data to Excel, I am getting a huge number for Time (seconds?) and what may be the distance in kilometers (see below).

How do I get the Elapsed Time field in hours:minutes:seconds so I can tally and format in Excel?

How do I set the DIstance to be in Miles (not what appears to be kilometers) such as 6.75 Miles? (My Profile already has selected "Miles").

Thanks for your help.

Elapsed Time	Distance
6069	14.55

[Jane · Accepted solution]

Hi @flashmason 

Thanks for posting about this.  It's not possible to choose another format for any data fields when you request your data export from Strava.  

The best workaround is to look for online calculators that will convert to the format you're looking for.  I hope that's helpful.