Automated Break Schedule

Hi Everyone,

Wondering if it's possible to do this:

Multiple people may have the same shift in a day. They will all have different breaks. Using VLookup I can reference breaks, however is there a way to have excel use the next available breaks ( based on a data sheet ) once the first one in a list has been used ?

Ive added a small spreadsheet to explain what I am trying to do. I guess I could do a shift like: 9:30-6:00. 9:30-6:01 and it would work, but I would rather not have to worry about remembering to add 6:01,6:02, etc



Thanks in advance,

Ron