Comparing Times To Make Sure No Overlap
 

Ok€¦I have a question and dont have a clue how this could be done. Right now
I have a spreadsheet with Case Date, Case#, Room Code, Start Time, Stop Time.
What I need excel to do is to 1) Make sure it is only comparing cases from
the same room code and comparing them only to the same date. 2)Then I need
excel to say compare the start time from row 2 to the stop time of row 1, and
let me know if row 2 started before row 1 was finished. Right now I am doing
a simple if statement. Does anyone know an easier way to do this? Let me
know if you need to know anything else.

Thanks in advance