Hello!

I am fairly inexperienced with Excel and need some assistance, I'm unsure how to word it so I will use pictures.

I have an employee schedule(below).

ssssssssssssssssssssssssssssssssssssssssss.PNG

I need the "Start" and "End" times on Picture 1 to auto-fill the time range on the worksheet in Picture 2(below).

adasdasaasaaasa.PNG

Additionally, I will need to be able to input the "Lunch" time as a different format into each employee's schedule row. I want everything to fill automatically based on the schedule data in Picture 1.

If anyone here can identify a method in which I can do this I have no problem teaching myself, I just don't know what you would call what I'm trying to do.
Thanks so much!