Hi I'm creating a tracker and I would need it to have a function to detect a schduling conflict of dates if any of the room 1,2,3 are reserved within the dates and times indicated from Column C to Column J. I am willing to modify the tracker if the function is easier to implement by adding a few columns in between to show the conflicts. For sample purposes, I have added an event in line 6 to show it is a conflict as room 3 has been reserved in line 2.
Any help would be appreciated
Hi Shamz41
I found your thread with no answer, so 'll try to help you.
First you need to determine the new row, as in the blue cells.
then I worked on the Pre-booking times, comparing if the new start is between the used times in previous bookings ( rows), the same with the end time.
if there is a coincidence in room and time, the first cell of the row is highlighted
I hope you can manage with the rest of the book.
Barriers are there for those who don't want to dream
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks