Time Overlap loop

Hi,

Can you guys please help me again with the spreadsheet that I'm working on I'm kind stuck on this.
I have a list of employee with their start shift and end shift, what I want is that when I click a button it will auto fill everything in User 1 and User 2 with a condition that their end/start shift shouldn't overlap.

So far this is the formula that I am using

Please Login or Register  to view this content.

But every time that I use that I am having a trouble if it compares to a user that is in 12:00AM.

I want to do this in Macro by the way and continuously loop in the Raw Data. Please see my attached sample excel sheet.

Thanks in advance.


PS: Can you make the code in a much simplified way, so that I can easily understand it sorry about that.

You may know what user 1 and user 2 mean, but from what I can see it's not obvious. You should go into a detailed explanation as to what your sheet means and give some examples of where and why we should see the words conflict and not conflict. Your formula references no cells so how can we know what you want by looking at your formula. You also have no data in the user 2 area so there's nothing there to make it any more obvious what you want. I looked in name manger, there's no named ranges.

This was in my previous post. I don't see where you responded to this. I can't help you if you don't respond to specific questions or concerns that I have.

You should go into a detailed explanation as to what your sheet means and give some examples of where and why we should see the words conflict and not conflict