Assuming your min/mile number is in A1 (ie. 20), your formula for miles/hour
is =60/A1. This gives you 3 Miles/Hr. The following table shows the times I
tested:

Min/Mile Miles/Hr
20 3
15 4
60 1
1 60

Don't forget to press "Yes" if this was helpful.

Thanks,
rzink

"Run 4fun" wrote:

I'm tring to set up a running log on excel and I want to create a formula
that converts my road pace (minutes/ mile) to a speed (miles / hr) so I can
enter that number on my treadmill. Sounds simple but the formulas I've tried
are giving me false results. Example: Walk 1 mile in 20min gives you a pace
of 20:00:00 and a speed of 3MPH. (60/20=3), but when I make the formula I get
answers like 0.1, 72, or 0