Format cell C2 as mm:ss

When you enter this time enter it as 0:37:41. It will show in the cell as
37:41 but in the formula bar it will show as 12:37:41 AM.

Then:

=C2/B2

Result is 09:25

You can format the formula cell as m:ss if you don't want the leading 0,
9:25

Biff

"tateh973" wrote in message
...
I'm a runner, and want to keep track of/work with my times. I want Excel
to
tell me what my average time is per mile. So let's say cell b2 is the
number
of miles (example, 4.0 miles) and cell c2 is my total time (37 minutes, 41
seconds). I want to know how many minutes per mile I've done. This is
probably really easy -- but Excel thinks I'm entering an actual clock time
(12:37:41 a.m.) vs. just a quantity of minutes/seconds. Can someone help
me?
Thanks.