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
What I would like to see is some visibility into Airtable’s development roadmap. It would be nice to see what features are on the fast-track, that are actively being worked on, what features are on the mid-range schedule, and what features are still ...
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 F...
If you plan or are thinking about using it for some type of system functionality, which is what it sounds like, I would definitely consider adding a comments/conversations table.
Yes, there seems to be confusion over the word “comment”. @DavidMa - a user adding additional content to a long text field is not what Airtable calls a “comment”. But to accomplish what you want to do, create a “comments” table that is linked to your...
Charles_Pendleton:
Kevin, your’s worked once the quotes were fixed, but I had to fix them in AirTable, not my Notes app on the mac as it just seemed to replace with the same - which I wonder if in one of my many attempts was part of the problem....
