Below is a sample to show what my typical excel sheet looks like. What I wish to know is: Is there a formula that will look up the time cell that my data changes. I have the following timetable for a teacher aide and wish to create a printing version that will say 9:00 a.m. to 10:30 a.m in the left column because that is when Maree works with Alisha etc.

Maree Monday Tuesday Wednesday Thursday Friday
9:00 a.m. Alisha Alisha Alisha Alisha Alisha
9:05 a.m. Alisha Alisha Alisha Alisha Alisha
9:10 a.m. Alisha Alisha Alisha Alisha Alisha
9:15 a.m. Alisha Alisha Alisha Alisha Alisha
9:20 a.m. Alisha Alisha Alisha Alisha Alisha
9:25 a.m. Alisha Alisha Alisha Alisha Alisha
9:30 a.m. Alisha Alisha Alisha Alisha Alisha
9:35 a.m. Alisha Alisha Alisha Alisha Alisha
9:40 a.m. Alisha Alisha Alisha Alisha Alisha
9:45 a.m. Alisha Alisha Alisha Alisha Alisha
9:50 a.m. Alisha Alisha Alisha Alisha Alisha
9:55 a.m. Alisha Alisha Alisha Alisha Alisha
10:00 a.m. Alisha Alisha Alisha Alisha Alisha
10:05 a.m. Alisha Alisha Alisha Alisha Alisha
10:10 a.m. Alisha Alisha Alisha Alisha Alisha
10:15 a.m. Alisha Alisha Alisha Alisha Alisha
10:20 a.m. Alisha Alisha Alisha Alisha Alisha
10:25 a.m. Alisha Alisha Alisha Alisha Alisha
10:30 a.m. MTea MTea MTea MTea MTea
10:35 a.m. MTea MTea MTea MTea MTea
10:40 a.m. MTea MTea MTea MTea MTea
10:45 a.m. Jake Jake Jake Jake Jake
10:50 a.m. Jake Jake Jake Jake Jake
10:55 a.m. Jake Jake Jake Jake Jake
11:00 a.m. Jake Jake Jake Jake Jake
11:05 a.m. Jake Jake Jake Jake Jake
11:10 a.m. Jake Jake Jake Jake Jake
11:15 a.m. Jake Jake Jake Jake Jake