Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Pre-determined times within formulas

Topic Labels: Formulas
350 0
Showing results for 
Search instead for 
Did you mean: 


I would like to calculate how long a project will take based on the number of components * various pre-determined times.

Here, for example, I’m saying that it takes 5 minutes to work on one Table. I would like to replace the 5 with 00:05:00, if possible. As this is an average time, I would like it to be part of the formula and not taken from another column.


(Datasets+{Time series}+{Supporting articles or methodologies}+2)*2
((Datasets+{Time series})*1)
0 Replies 0