Count average time to close action
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.
Help Article Resources
Check out the Formula Handbook template!