View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Can excel count concurrent events given start and end times ?

Yesterday I stared at this for about an hour trying to figure it out.
JLatham's point about your desired granularity is an important one,
since it is an important aspect of your solution. I made some
assumptions about "down to the minute" granularity and tried to
develop a way to determine calls originating during a particular
minute and calls that were ongoing during a particular minute, and
couldn't get the logic down, and then couldn't devote more time to it.

The best I can figure right now is to calculate calls in progress
during a particular time frame by listing for each call the start and
end time; use your desired time granularity as headers across columns;
then use IF statements to determine if a call is in progress during a
given time period. If TRUE then return 1 in a given cell, and at the
bottom of the column sum all the 1s. That's not very elegant, tho,
hopefully one of the resident geniuses can respond with a better
method.