Scheduling production orders

Hello everyone!

In my attachment you can see 2 tables that represent the weekly production orders in a filling production line.

In the first table, in the first column I have the quantity of products that are needed. The second column is the description of the product to be produce. In the third column I have the quantity of hours that are needed to produce the product (eg. 3,843 = 3 hours and 51 minutes). Then I have the begininng hour and data of the production and the end. The remaining hours are for doing the changes to produce the different products (last collumn - setup time). The production line is scheduled in 2 shifts of 8 hours with a 30 minutes breaks. From 07:00 to 15:30 and 15:30 to 00:00.

In the other table, I need to determine what is the quantity of products that I need to produce each day, having in count that the line is programated 2 shifts and it's only when the operators are there that I can produce.

In the attachment you can see what I'm trying to do. I'm having problems because because I'm new to Excel functions.
I hope I have explained my problem well.

Can you help me please?

Thanks a lot!

Regards,

João