Divide a number into multiple cells based on logic

Hello,
What I am trying to do is log hours daily and enter the daily total into a cell say (B7, B8...). Then I want to divide the cell, say B8 evenly into four categories. Each category has a maximum number of hours required and once that maximum number is reached I want to stop dividing into that cell. Like in the example below, we have 8 hours on Day 1 and since Cat A and Cat C are at their max 250 hours we don't divide into those. We show 4 hours in Cat B and 4 hours in Cat D.

Right now I have a conditional format that just changes the text in the 'Hours' column to red once the limit of hours is hit and we are dividing by number of open categories and manually entering into the categories that are not full.
What we would like to do is just enter the hours per day and have that number automatically divided and reported into the categories that have not reached their set maximum. If there is any way to do this with a formula it would be preferred over macro. Any advice or help would be greatly appreciated! Thanks, Jeff.

Cat Hours Hours Day 1 - Hours Day 2 ....
A 250
B 100 4 4
C 250
D 25 4 4

ENTER DAILY HOURS: 8 8

Hi Glenn, thank you. I was having trouble with the attachment on the original post.
I have uploaded the attachment on this post, let's see if I was successful.

Jeff

Hi Siva, the trick is to divide by the number of open categories. In your example, you have satisfied the 2nd category which leaves 3 categories unsatisfied.
We would divide 8 / 3 = 2.66, so 2.66 would be calculated into each of the 3 open categories. Then once we have satisfied the next category, we would be dividing by 2 and so on...

Thank you,
Jeff