How to calculate running pace

[Kevin_Conklin]

I have a table with distance run as a number, and time to run the distance as a duration. How can I use a formula field to calculate average pace (mm:ss/mile). I would think it would be (duration / distance) but obviously, that does not work.

Thanks

[Danny]

Hey Kevin,

What’s not immediately obvious is that behind the scenes, the duration field is stored in seconds. So to get the correct calculation, you’ll have to make the conversion from seconds to minutes by dividing duration by 60 first :slightly_smiling_face:

[Kevin_Conklin]

After more playing around with it, it does not seem that you need to convert from seconds. there are 2 ways it worked:

(duration/distance)
or
((duration/60)/distance)*60

Both worked when the formula’s formatting was set as:
Duration (1:23)
Duration Format: h:mm:ss