Production Line Calculation

Im trying to find out how am i going to calculation a production line of 30 people and then i need to calculate against the finished production product database workings.

Tough im trying to make something acurate we work 8hours a day so 1 day isnt 24 hours, and then we dont work on Saturdays an Sundays so i need to skip them too, and there are public holidays etc. Which means if I find a way to do the mentioned situation I can calculate The Delivery dates of when the products will finish.

Thanks in Advance.

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

Im trying to find a solution before working my workbook, im not sure what i need to show as an example since im not really sure what to do for the solution. Any Ideas?

Most of issues in excel need unique approach - depending of input data.
Some similliar questions can have totally different approach.

So yes, it is possible but for some better answer you would need to create some example workbook: how you input data look like, what you enter, write your desired result.
Creating more different examples (for more people and more time) you can get better answer.

Most of issues in excel need unique approach - depending of input data.
Some similliar questions can have totally different approach.

So yes, it is possible but for some better answer you would need to create some example workbook: how you input data look like, what you enter, write your desired result.
Creating more different examples (for more people and more time) you can get better answer.

And what do you expect as a result? (Write number, not formula, just to see what you expect).

Updated with more information.

Now we making progres.
I've defined holidays in Holiday tab (you can add them below as new come, no need to delete old ones).

Also, I assume 1,49 need to be rounded to 2 (actually, anything that is 1.x need to be rounded to upper value).

Then use Workday function.

Thanks alot, im working on the database of the workings of every product in our catalogue, after i will implement the calender.

If i have any other enquiries shall i post new thread or continue on this one?

If it's new question then new thread.
If you continue to this question you can ask here.

And don't forget example workbook That will bring you solution in minimum time.

I need to priorotize by confirmation date before calculating starting Date and Delivery date is there a way to do so ?

What do you mean by "priorotize" ?

make priority sorted by red indicated Confirmation date.

Is there a way to calculate 1 day as 8 hours of working period for the "Worker 1 time" X "Quantity of Product" = Answer
Therefore it needs to calculate as if there is a 1 hour job it calculates that there is still 7 hours that is able to work another job while there can be multiple small jobs for 1 day.

And for the "Delivery Date" i want to Deliver at Least 5 Jobs a Day Maximum is it possible to do so?

Im going to attach a sample document.

I don't understand.. but maybe this in B26: =(INT(B25/8)+1)*8-B25

So on 30 hours, answer is 2 (8*4 = 32 so remain 2 hours for something else)?