Employee schedule hours tracking

So what I want is something that will keep track of the hours an employee is scheduled. The wall I've run into is this:

I have a Sheet for Thursday with:
"A6:A34" holding the Employee's names (text)
"B6:B34" holding Start Time (hh:mm)
"C6:C34" holding end Time (hh:mm)
"AL6:AL34" holding Hours scheduled (in HH:MM though converting it to decimal format would be acceptable, maybe even preferred)
"A37:A67" holding the employee roster (text)
"G37:G67" holding the "solution/formula in question" or number of hours scheduled

What I want is to be able to enter the names that I want in "A6:A34"
Then I want "G37:G67" to display the number of hours that the employee is scheduled (taken from "AL6:AL34") Preferably in decimal format
I will then desire for it to keep a running total on sheet 'schedule Friday!', 'schedule Saturday!'...etc.
I will put one of these on every day so that I can keep track of how many hours that I've scheduled them for as I go (if I've finished Wednesday before Friday then I want to see the total on Friday so I know if the employee is approaching the max.

I know that it's complicated but It's a whole big thing spread across multiple sheets and holding way too much data. This is the first wall that i've really struck. It's all a work in progress but if you guys could help, I would be super grateful. Thanks!!!

Hi and welcome to the forum

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Are you sure you uploaded the right file?

G37:G67 is the 09:00 time slot, and there are no sheets called 'schedule Friday!', 'schedule Saturday'...in fact there is only 1 worksheet in that workbook?