Not sure what formula to use to set up work schedule

I'm trying to redesign the work schedule for a 24 hour police dispatch center. I'm trying to figure out the most efficient way, and I've looked at using vlookup, match and index and still not sure how I should do it. I need to create a list of employees on duty in 2 hour increments throughout the day by looking at the main schedule to see if they are working, then look at the time they are on duty, and then list the employees on duty at that time by seniority. For example, I need to list employees on duty from 1200 pm to 200 pm, but at that time there are 3 overlapping shifts to look at and then I have to put it in seniority order. I don't want my list to have any blank spaces and I cant delete any rows. Finally, I don't want to use macros. I'm attaching a template to you can see what the daily schedule looks like.

I'm familiar with Pivot Tables, but I'm not sure how I can use them for this purpose. I'm attaching a sample schedule template as well as the daily assignment sheet that was attached to the original post. As you can see, everyone has different days off and there are different shifts. What I'm looking for is to create a list, for example, of all employees who are on duty on a Tuesday at 1200-1400, and I have to refer to the calendar because it may be their regular day to work, but if they are on vacation (as indicated by a V), then they don't need to be on the list.

If the following are your requirements, I'm afraid I would not be able to assist you.

I don't want my list to have any blank spaces and I cant delete any rows. Finally, I don't want to use macros.

Sorry sir, hopefully someone else on the Forum may be able to come up with a ready solution for you.

Maybe if you could include a sample Sheet or Sheets of what the result/s should look like, it could make it easier for the Pro's to help you.

Good Luck!