View Single Post
  #1  
Old June 2nd, 2010, 06:51 PM posted to microsoft.public.excel.misc
Run 4fun
external usenet poster
 
Posts: 1
Default convertion formula for (min/mile) to (mile/hr)

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