I'm having trouble calculating the per mile pace in road races. Example: A runner runs a 6.2 mile (10k) race in forty four minutes and 13 seconds, given as 44:13. What is the average time (pace) per mile? Seems easy, but... Also, what if time is given as 44.13? This also needs to work for total times over one hour. I can do the calculations on paper but how do I get Excel to handle the colon and do the calculation?
With Great Humility,
Runner[/b][/i]
With Great Humility,
Runner[/b][/i]