Count average time to close action

sahilhq ✭✭✭✭✭✭
edited 04/18/20 in Formulas and Functions


Can anybody please suggest me with a formula that would calculate the average time a person takes to close an action assigned to him in a row? I have attached below the layout of the sheet. The formula should calculate the start of the time from when the date raised changes to a value and return a value in the time taken column when the status is closed. It would be great if the formula could consider the exclusion of weekends and bank holidays.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!