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
Bookmarks