software

Hiya's,

I'm a walker and I like to keep track of my miles and times. I'd like to be
able to use excel to figure my miles per hour. I keep track of the miles in a
number format..i.e. 8.67 miles. And I keep track of my total times in a time
format...i.e. 2:15:13. This would be 2 hours 15 minutes amp; 13 Seconds.

I have no idea how to set up this formula. Any suggestions would be greatly
apreciated.


WalkerDude999 Wrote:
gt; Hiya's,
gt;
gt; I'm a walker and I like to keep track of my miles and times. I'd like
gt; to be
gt; able to use excel to figure my miles per hour. I keep track of the
gt; miles in a
gt; number format..i.e. 8.67 miles. And I keep track of my total times in a
gt; time
gt; format...i.e. 2:15:13. This would be 2 hours 15 minutes amp; 13 Seconds.
gt;
gt; I have no idea how to set up this formula. Any suggestions would be
gt; greatly
gt; apreciated.

If miles are in cell A1 and Time is in cell B1, in cell C1 enter

= A1/B1/24.

After entering the formula use Format gt; Cells gt; Number to change the
format of cell C1 to something other than Date/Time.--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=539616