Results 1 to 5 of 5

Thread: Tracking schedule confllicts

  1. #1
    Neophyte spudulene's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    Excel 2016

    Tracking schedule confllicts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I apologize, but I am new here and my thread has not appeared yet. I am sorry if I am sending this multiple times.
    I am a professor and I want to correlate multiple student schedules to see when there are the fewest number of conflicts.
    Count is important. Below on the right are the data that would be used to populate the table on the left.
    I have created the table on the left manually, so one can see what it should look like after using the formula.
    For example, there are two times on the right that cover T(uesday) from 8:30 - 8:45. The full spreadsheet would go from 8:00 am - 5:00 pm and have a couple hundred days, start and end times.
    I would consider myself and intermediate excel user. I tried multiple attempts using countifs statements, but could not get past the first row of input data. Any help would be appreciated.


    Time Day Days Start End
    M T W R F TR 8:00 9:00
    8:00 0 1 0 1 0 W 9:20 9:45
    8:15 0 1 0 1 0 MWF 9:00 9:50
    8:30 0 2 0 1 0 T 8:30 8:45
    8:45 0 2 1 1 1 WF 8:45 9:45
    9:00 1 1 1 1 2
    9:15 1 1 2 1 2
    9:30 1 1 2 1 2
    9:45 1 1 0 1 1

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,675
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi and welcome
    please post a sample sheet.Click " Go advanced - Manage attachments" and follow the wizard. Thanks
    Thank you Ken for this secure forum.

  3. #3
    Neophyte spudulene's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    Excel 2016
    Here is an excel file with the data above.
    Thank you.
    Attached Files Attached Files

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,604
    Articles
    0
    Excel Version
    365
    Does the attached give the right answers?
    Attached Files Attached Files

  5. #5
    Neophyte spudulene's Avatar
    Join Date
    Aug 2019
    Posts
    3
    Articles
    0
    Excel Version
    Excel 2016
    Wow! That is awesome. The answers were correct (and the one I hand generated was not, .) I guess I can make that as long as I want by expanding the times on the left, changing the fixed range for the three columns on the right in formula in cell B3 (first cell with formula) and copying that to the rest of the table. I will play with it. Thank you very much.

Posting Permissions

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