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.