How to calculate average speed/pace?

[pipps]

I have a spreadsheet here which I am using to calculate my intended progress on an ultra-marathon that I am running in two weeks' time.

The distance for each stage is in Column B. In Column C, I first need to state my average pace. Based on the facts below, how should I calculate this?

From the start, I plan on running for 5 miles and then walking for 1 mile. When running, I will be travelling at a pace of 10:00 minutes per mile (min/mi) or 6.0 miles per hour (mph), and when walking I will be travelling at a pace of 15:00 min/mi or 4.0 miles per hour.

On this basis, how should I calculate my total estimated time taken to cover a given 6 miles at this combined pace please? What would be the formula to use?

Please forgive what must seem like a rather basic question, but I am not so numerically gifted as so many here. Thanks

 

[Tyron]

Hey wigi,

Yes, see those comments helped alot. I would have never thought to come at it from that angle. I was so caught up with the fact that his running/walking was a certain way and that the mileage for each section was unable to conform to those variables that I got confused.

Thanks again for your help. I am hoping that the original poster finds that it works for him just as well as the non-VBA version.

later

Ty

 

[Fazza]

A big run, Winter 100 2014 | Centurion Running | Ultramarathons

Cut off 30 hours. Gulp!

All the best, Pipps