+ Reply to Thread
Results 1 to 3 of 3

Count of current chats (time intervals)

  1. #1
    Registered User
    Join Date
    06-29-2013
    Location
    Kev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    2

    Count of current chats (time intervals)

    Good day to you all!

    I would greatly appreciate any help with my question.

    I have a statistics of online chats, including information about when has the chat started, ended and its duration. What I need to count is how many chats are there at a time, occurring simultaneously (my global goal is to calculate chat density).
    I guess the best way to do would be to count the number of current chats at the start of the new chat (which means a number of chats at a certain time).
    Or is there a way to calculate not only a number of chats at a certain time, but also on certain interval of time (like once in 10, 15, 30 minutes)?

    Here is an extract from the table. "Count by formula" - these are the values obtained from the formula in this thread, but apparently it's not what I look for. One chat can last for long, the other chats come and go so the number of overlapping chats may go higher and higher and be quite far from the numbers I am actually after.
    Chats.xls

    Thanks everyone. Please except my apologies if my request is not completely clear.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Count of current chats (time intervals)

    Try

    =SUMPRODUCT((B$2:B$15<=B2)*(E$2:E$15>=B2))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-29-2013
    Location
    Kev, Ukraine
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Count of current chats (time intervals)

    Thanks a lot! It seems to provide just the right results!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1