Count average time to close action

Count average time to close action

sahilhqsahilhq
edited 04/18/20 in Formulas and Functions

Hey,

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.

Thanks,

Sahil


Best Answer

Sign In or Register to comment.