Help

Pre-determined times within formulas

Topic Labels: Formulas
808 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ONS_Publishing
4 - Data Explorer
4 - Data Explorer

Hi,

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.

Thanks!

(Datasets+{Time series}+{Supporting articles or methodologies}+2)*2
+
((Words*4)/500)
+
((Charts+Interactives)*3)
+
Tables*5
+
((Datasets+{Time series})*1)
0 Replies 0