Auto Scheduling of volentary overtime past normal working hours

[Draylob]

I am trying to figure out how I can have Employees overtime auto populate from their regular work schedule & their availability for secondary overtime work. Ive been trying IF functions but I am not have the result I am looking for or work at all most of the time.

I want to be able to just enter the employees availability for the week & the spreadsheet automatically generates the schedule.
I am also trying to keep each employees total hours to 72 or below if possible.

Can anyone give me a hand with this

[JeteMc]

Hello Draylob and Welcome to Excel Forum.
If I understand correctly try the following:
1) Type the date 1/29/2018 into cell H4 (1 Feb is a Thursday) and drag across to N4 which should read 4 Feb,
2) Select cell H7 and paste the following formula into the formula bar:

Please Login or Register  to view this content.

3) Drag the fill handle across to cell N7, the values in H7:N7 should match what was manually input into the file attached to post #1.
Let us know if you have any questions.