Visit Schedule

Can anyone help me? I've been struggling with this all week to no avail.

I have a structured table of visits (Table name: CMSVD1)

I want to display this data in a new structured table (Table name: Schedule) using five minute intervals (Column A), in such a way that I can clearly see if visits overlap and where there are gaps in the round.

As you can see, my plan is to use three lanes like lanes on a highway where if a visit occupies the first lane, a second visit that overlaps in CMSVD1 must occupy the second lane and so on. The formulae in the lanes must check that the Round value in CMSVD1 is BAR-AM P1.

Please try in test!B2 and copy to the right and down:

Formula:

Please Login or Register  to view this content.

It doesn't look exactly as requested, but it's close.

Is this enough? The last step is not so easy.
And certainly not within an Excel table.