divide a total of hours in several days according to rules

[Lux Aeterna]

I've tried asking that question before, but I didn't make myself clear, so I am posting it again with some more explanation.

Here is our monthly schedule.
- We work from Monday to Friday for 7 hours (regular). Arrival and departure times are standard, so that was the easy part.
- We are also getting a bonus for 20 more hours per month (overtime). What I need to do is to spread those 20 hours to the days we have worked automatically.

This means that if we work for 22 days, we can have any "combination" of overtime hours as long as it sums up to a total of 20. For example, we can have 20 days of 1 hour overtime (and 2 days of zero overtime), or 10 days of 2 hours overtime (and 12 days of zero overtime), or 10 days of 1 hour and 5 days of 2 hours overtime (and 7 days of zero overtime).

Limitations
Max overtime per day is 20 hours.
We can work either 1 or 2 hours of overtime (i.e. not 20 or 30 minutes)

I can upload excel file if necessary.

Hope someone can help!

 

[Joe4]

Duplicate to: Cannot think of a short title, see whole post please :)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted. Please continue in your original thread, with any clarifications that you need to add.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.