I need help! I'm working right now and I need the cells a certain way or i'm
in big trouble. I'm supposed to have it like this:

Hours
11
regular 8
overtime 2
double t. 1

I need a formula that I just type in that 11 at the top first cell, and then
it will auto sum into the other 3 cells underneath, but a maximum of 8 hours
in the first cell, so then it will move on to 2 in the second cell but a
maximum of 2 in the second cell, so all the other hours go to double time.
Please help?

Two answers in other copies of your much duplicated (courtesy of the site's
inability to decide when it really has a problem or not) request. Either
solution should work fine. Hope they work better for you than the system has
been here for the past several days.

"Anthony A." wrote:

I need help! I'm working right now and I need the cells a certain way or i'm
in big trouble. I'm supposed to have it like this:

Hours
11
regular 8
overtime 2
double t. 1

I need a formula that I just type in that 11 at the top first cell, and then
it will auto sum into the other 3 cells underneath, but a maximum of 8 hours
in the first cell, so then it will move on to 2 in the second cell but a
maximum of 2 in the second cell, so all the other hours go to double time.
Please help?