Sunday, August 12, 2018

yogi_Calculating Concurrency with Start Times/End Times and Duration

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!!!



1 comment:

  1. Hi Yogi,

    in 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?

    ReplyDelete