This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

exporting activities to csv file

Former Member
Former Member
I am using a Forerunner 15 I have exported my activities in a csv file from Garmin Connect.
When I open the csv file in excel, the time for an activity shows in the spreadsheet columns as 11:08, 10:56 etc which look likethe correct values.
However if I look at a time in the excel editing bar, it shows as 11:08:00 AM which is an actual time, not the time taken for an activity.
I want to convert the time for an activity from mins:secs to a decimal time eg 11.13 mins.
Could someone show me how to do this please?