Friday, 18 April 2014

How to Add Mile Splits in a Spreadsheet

The solution is Google Drive spreadsheets. To add up mile splits in a spreadsheet:

1) Open up a new Google Drive spreadsheet.

2) Enter in your mile splits in the hh:mm:ss format such as 0:10:30 (0 hours, 10 minutes, thirty seconds), then enter the next time split below that one.

3) Select all the times and then click on the “More Formats” button in the menu (the “123″ button) and select “Duration.”

This is what that looks like.

4) Now you can select those same spreadsheet cells again and click on the Sum formula (the Sigma shape) button and it will display your time in a nice hh:mm:ss format.

This is what your properly formatted column of time splits with total time will look like.

Now you have your splits and you can use this for training and for your race. Now you can write the mile splits on your arm, tape them to a water bottle or even send away for temporary tattoos with the time splits on them


If you are searching for best CRM software, then you have landed at the right place. We are the best in providing best CRM solutions and once you avail Techvedic, you say no to pessimism and stagnancy.

About Techvedic:

Get in touch with Techvedic on Social Media:

Techvedic Facebook Page:
Techvedic Twitter:
Techvedic Google Plus Page:
Techvedic YouTube:
Techvedic LinkedIn Profile:

Visit: Techvedic – Customer Relationship Management | | 1 800 3000 1126 |


Post a Comment