Schedule production allowing for part days

[BRISBANEBOB]

I am trying to find a formula to copy across a schedule and see how many units in total are produced daily and when. The attached spreadsheet explains it better. Grateful for any assistance.

Thanks

[JohnTopley]

Why is K9 "=D9*0.75" (rather than sequence of 7, 7, 4) for row 9?

[JohnTopley]

... See now ... part production on "overlapping days" !!!!

[samba_ravi]

I think K9 SHOULD BE 1.75 instead of 5.25

[samba_ravi]

If I am right use below formula and copy across
H8

Please Login or Register  to view this content.

[BRISBANEBOB]

I have been staring at your formula for 15 minutes and I have no idea how it works but it does! Perfectly! Thank you.

[marokgd]

could You please send me this file completed ? I am working on something like that too but when i pase formula to Your excel it says some error and i do not know why. says it is missing some ' with first MIN .

Thanks

[samba_ravi]

could You please send me this file completed ? I am working on something like that too but when i pase formula to Your excel it says some error and i do not know why. says it is missing some ' with first MIN .

Thanks

see the attached file

[marokgd]

Another question:
if i want to make certain days as holiday days and want production to skip to the nearest working day....how to do it ?

and i would like to decide which days are holidays for example bein put from some data somewhere in sheet 2 or something