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!
Bookmarks