How to Add Mile Splits in a Spreadsheet

I’m preparing for the Ojai Half Marathon on April 27 and it’s a hilly course so I’m setting up target mile splits for race day. When I ran my first half marathon this past December it was a very flat course and my main goal was just to finish while keeping an eye on my heart rate.

But once you set up your goal mile splits, you’re going to want to figure out your total time and that’s where I ran into a problem. I’m fairly proficient with Excel but I fumbled around for a good 20 minutes before I started Googling easier ways to accomplish the task without doing it manually.

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