+ Reply to Thread
Results 1 to 5 of 5

finding overlapping times on the same date

  1. #1
    Registered User
    Join Date
    04-10-2015
    Location
    hawaii
    MS-Off Ver
    03 excel
    Posts
    3

    Exclamation finding overlapping times on the same date

    Aloha everyone!
    I'm hoping someone can help me out with this issue I'm having. I need to figure out a way to locate overlapping times. The problem is that there are other factors that need to be true in order for it to be considered an overlap. see attached. I need to locate overlapping tutoring times that are associated with the same teacher on the same date. The actual spreadsheet I'm working with is gigantic and involves 30+ teachers and over 150 students, so being able to do this would help identify fraudulent tutoring.

    Any help or suggestions would be highly appreciated!!

    Mahalo!
    Vicki
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: finding overlapping times on the same date

    In your actual file, are the teacher IDs sorted? Or is it possible let it sorted by teacher IDs before working on it?
    Quang PT

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: finding overlapping times on the same date

    See attachment. I use helper columns to show each row is overlap or not
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-10-2015
    Location
    hawaii
    MS-Off Ver
    03 excel
    Posts
    3

    Re: finding overlapping times on the same date

    Hi, Bebo!
    Yes, the i am able to sort by teacher ID beforehand.

  5. #5
    Registered User
    Join Date
    04-10-2015
    Location
    hawaii
    MS-Off Ver
    03 excel
    Posts
    3

    Re: finding overlapping times on the same date

    this is perfect! thank you so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding overlapping date periods for specific variables
    By pickaside in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2019, 10:00 AM
  2. Finding overlapping mm:ss within a date
    By sdaniel75 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2014, 07:00 PM
  3. Need help with overlapping times
    By k.mack0215 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2013, 05:21 PM
  4. [SOLVED] Finding Overlapping Date Entries with matching IDs
    By Zabaran in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2013, 06:30 AM
  5. finding # hrs between 2 date times
    By TechRetard in forum Excel General
    Replies: 10
    Last Post: 04-18-2010, 02:04 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