Thread
:
convertion formula for (min/mile) to (mile/hr)
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips[_4_]
external usenet poster
Posts: 834
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
Reply With Quote
Bob Phillips[_4_]
View Public Profile
Find all posts by Bob Phillips[_4_]