John,

You should probably convert the time to seconds, then figure the seconds per mile. Something like this:

SecPerMile= ((NumHours*3600) + (NumMinutes*60) + NumSeconds)/Miles

You can then convert the seconds back to minutes and seconds like this:

Minutes=INT(SecPerMile/60)
Seconds=SecPerMile%60

>Hi all,
>
>Real basic formula needed for calculating a time per mile.
>
>For instance, if I ran 10.5 miles in 1hr 10min and 15 seconds, what is the proper way to calculate the per mile time? I have come up with a simple calculation but It's not always reporting the correct minute/secs per mile.
>
>Any ideas?
>
>Thanks.
>
>John.