hi
a simple solution would be
b2 number of miles
c2 number of minutes
d2 number of seconds
in d3 convert the seconds to minutes e.g. =d2/60
To work out miles per minute suggest the formulas =b2/(c2+d3)
to work out minutes per mile will be the inverse e.g. =(c2+d3)/b2

this may seem long winded someone else might have a more straighforward
way

On Jan 1, 9:25 pm, tateh973
wrote:
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.