From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Running totals, splits, and times

Running totals, splits, and times - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Running totals, splits, and times

“

- [Instructor] Raqeema is going to run a 10-mile race, and she wants to do it in an hour and 53 minutes. Now the twist. She wants to run the second half in 50 minutes, and your job is to calculate the splits and the pace. And in case you need a little assistance, let's look at the example sheet. Here, is someone running a 10-mile race in an hour and 30 minutes. The pace shows the time for each mile. So mile seven, the goal is to run it in eight minutes. And at the end of mile seven, this runner should be at an hour, six minutes. Let's go back to the challenge. Now your turn. Pause the video. Get those splits and pace data, and then come on back. (upbeat music) Okay, let's run this down. I'm going to slide this out of the way a little bit. Yeah. Okay, so let's do this. First half and second half. Now, let's do the second half first. The second half, we want to run in 0:50:00. Good. First half…

Contents