Average Turnaround Time

Dan Colosi

1)    I have a column for turnaround time, which calculates end date minus begin date, considering holidays and workdays. I then do a summary formula which averages the total turnaround time.

2)    I have another column duration, which calculates today's date minus the begin date.

3)    I have another column that is a status of either HOLD, APPROVED OR REJECTED.

 

The problem with my average turnaround formula is that it doesn’t take into account the turnaround time for those that are on hold because there is no end date yet. How would I calculate turnaround time for both end minus begin dates AND the duration of HOLD rows?

Paul Newcome

You would need to use something as an end date. I personally use tomorrow plus the expected duration as a "placeholder" date.

Dan Colosi

Thanks Paul. I was able to SUM up the amount days for the beginning and end dates as well as SUM up the HOLD duration days using IF AND formulas. I then added the those sums for a total. I also counted the total # of requests, in which I used the total sum divided by the count and got the live average.

Paul Newcome

Great! Glad you were able to find a working solution. 👍️