Thread: convertion formula for (min/mile) to (mile/hr)
View Single Post
  #2  
Old June 2nd, 2010, 07:02 PM posted to microsoft.public.excel.misc
Bob Phillips[_3_]
external usenet poster
  
Posts: 489
Default convertion formula for (min/mile) to (mile/hr)
If A2 holds the time, try

=N(60/(A2*24*60))

--

HTH

Bob

"Run 4fun" Run wrote in message
...
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