Average Turnaround Time
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?
Answers

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

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.

Great! Glad you were able to find a working solution. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!