
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 28, 2018 12:15 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 28, 2018 12:24 PM
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 28, 2018 01:02 PM
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
