The Ojai Half Marathon was my second half marathon, the first being the Santa To The Sea race in December. The Santa To The Sea was on a very flat course with an elevation loss but the Ojai race features a bounty of rolling hills.
Ojai Half Marathon
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: