Ok this one, in my mind is complex. I'm hoping someone can tell me I'm wrong.

Scenario:
Creating a weekly schedule breaking out each Day as its own sheet with at least 30 users listed.

Breakdown:
1. Each sheet has 15 min increments for scheduling
2. Each cell within those 15 min increments has a letter associated to it
3. Each letter signify's something that needs to be read
4. Timeframe is 24 hour days

What I am trying to do:
1. I used Data Validation to make a listing of names for those on the schedule
2. I've made a simple table, each line is a day representing that tab
3. I would like to provide a simple view to those scheduled
4. The below table can be changed
Day Date Phones Lunch Meetings
Monday 8/6/2018
Tuesday 8/7/2018
Wednesday 8/8/2018
Thursday 8/9/2018
Friday 8/10/2018
Saturday 8/11/2018
Sunday 8/12/2018

Problems:
1. Those letter's above under breakdown (3), they signify the start/end times for coverage.
1a. They could have breaks in between those times. Example: Shift is 8am-430pm, Letter A is in cells corresponding to 8:00 AM to 10:15 AM and 2:00 PM to 3:30 PM. I want to show the start and end times for each breakdown

Person 8:00 AM 8:15 AM 8:30 AM 8:45 AM 9:00 AM 9:15 AM 9:30 AM 9:45 AM 10:00 AM 10:15 AM 10:30 AM 10:45 AM 11:00 AM 11:15 AM 11:30 AM 11:45 AM 12:00 PM 12:15 PM 12:30 PM 12:45 PM 1:00 PM 1:15 PM 1:30 PM 1:45 PM 2:00 PM 2:15 PM 2:30 PM 2:45 PM 3:00 PM 3:15 PM 3:30 PM 3:45 PM 4:00 PM 4:15 PM 4:30 PM
John Smith A A A A A A A A A L L L L A A A A A A
Jane Smith B B B B B B B B B M M L L L L D D D D D D D D