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
How to calculate running pace
+2Hey 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:
+2After 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.