Hello.

I have a spreadsheet into which I am importing time values. These are elapsed times for walking/running activities. They appear in the spreadsheet as 1:10:36 (hours-mins-secs) or 58:20 (min-secs).

In this format I can’t use them in calculations for working out average speed and/or average pace. The calculations happen but give wildly incorrect results.

Is there a suitable format available that will convert these to decimal hours that I can use in calculations? If not can anyone suggest a formula I could use to do the conversion?

Thanks in advance.