Right, Biff! I read miles per minute

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
Keep discussions in the newsgroups- no private emails please
"T. Valko" wrote in message ...
| 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.
|
|