Results 1 to 4 of 4

Concurrent Tinmeframes (SUMPRODUCT)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Concurrent Tinmeframes (SUMPRODUCT)

    Looking for an Excel formula that counts the intersecting, concurrent timeframes for each person. See attached spreadsheet.

    I am currently using a SUMPRODUCT formula as shown in Column E. However, it is incorrect, as it over-counting the number of intersecting timeframes. Column F shows the count as it should be.

    I am trying to count only the number of timeframes that actually intersect with each other. In one case, one timeframe is shown as 9:00am to 5:00pm for individual "Rob", and then two other timeframes of 9:00am to 11:00am and 1:00pm to 5:00pm. The maximum number of intersecting timeframes should be "2", not 3 (even though the 9:00am to 5:00 timeframe covers all the timeframes, it only intersects with one other timeframe at a time).

    Any ideas? Thanks..
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concurrent Count
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-05-2015, 04:19 PM
  2. [SOLVED] Concurrent macros
    By astrikor in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-25-2015, 09:53 AM
  3. Concurrent calls
    By hosseinb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2015, 09:47 AM
  4. Help with Concurrent occurrences
    By Backroomgeeza in forum Excel Formulas & Functions
    Replies: 41
    Last Post: 01-24-2013, 12:36 PM
  5. Concurrent using problem.
    By ramkumar_cpt in forum Excel General
    Replies: 0
    Last Post: 02-17-2006, 06:26 AM
  6. Concurrent Saving
    By MattShoreson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2005, 09:07 AM
  7. No of concurrent users
    By st120869 in forum Excel General
    Replies: 0
    Last Post: 01-25-2005, 05:05 AM

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