Results 1 to 4 of 4

Overlapping Time Intervals - Formula to Show Start Overlaps

Threaded View

  1. #1
    Registered User
    Join Date
    10-12-2017
    Location
    New York
    MS-Off Ver
    MS 2016
    Posts
    6

    Overlapping Time Intervals - Formula to Show Start Overlaps

    Good morning,

    I have previously posted a question in regarding time interval overlaps. https://www.excelforum.com/excel-gen...ml#post4763725 (Thank you 63falcondude!)

    I have a followup question regarding the same data. I have a limited amount of spaces to book, but many "classes". What I would like to create is a formula that can show me how many courses are in session at the start time of each course, so I can tell if I can "recycle" a space.

    Attached below is an example of what I would ideally have the spreadsheet appear like, with the "courses in session at start" the summary tab that will show how many rooms are filled at the designed start time for that row. I would need the information compiled much like in the way that Row P is now. For example, P7 (highlighted in orange) shows that the 4:50-6:50 courses have been released, freeing up the space it occupied, which can be re-used for the 7:00 classes.
    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. Replies: 11
    Last Post: 10-24-2016, 08:12 PM
  2. Calculating the overlapping time intervals
    By Mukund03 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2015, 07:20 PM
  3. Overlapping Time Intervals of the Same Date
    By cworkman123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-12-2015, 11:21 AM
  4. Sum overlapping start end time intervals
    By Jack-of-Trades in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-15-2014, 12:56 PM
  5. [SOLVED] controlling whether a list of intervals overlaps with a second list of intervals
    By Nicolas951 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 03:47 PM
  6. [SOLVED] Excel Formula to Show Type of Shift Based on Start and End Time
    By bjnockle in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-03-2013, 09:48 PM
  7. Show overlapping FY's from a Start Date and Duration
    By leaning in forum Excel General
    Replies: 7
    Last Post: 12-16-2010, 12:48 PM

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