Google Spreadsheet Post #2485
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Aug-11-2018
question by: Anders Vonderheyde
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/fHalIMqftkU;context-place=mydiscussions
Calculating Concurrency with Start Times/End Times and Duration
Hi all,
I'm looking to calculate chat concurrency. In my case, this is defined as: on average, how many chats is a rep handling at the same time? I have chat start times, end times, and chat durations listed in seconds. What is the best way of calculating this overall? I've included a screenshot of a little glimpse of the data below. Happy to share the doc with the full dataset with someone as well. Thanks!!!
Hi Yogi,
ReplyDeletein this example above, the concurrency is limited to "TWO" chats at a time. But what if the limit is "4" which will I change in the formula to reflect this?