Average minutes per mile
Enter 0:37:41
Time in Excel is stored as a fraction of a day.
So with your distance in B2 and your time in C2:
=B2/(C2*24*60)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"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.
|