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