Set a value range to reference another cell

[PlumGr8]

Been playing around but not sure if i can easily do what i am trying to do. I am working on an hours calculation sheet, and i want to break it down between Reg Pay, OT and DT. If i have say cell A5 that says "15" Hrs worked, is there a way to break down the 15 from there? Meaning if i have Reg Pay in C5, OT in D5, DT in E5, can i set cell C5 to display a value equal or less than 9, another formula for D5 to display 9 to 12, and E5 to display greater than or equal to 12, all based off the value entered in A5?

 

[Z51]

These will show the number of hours in each bucket, e.g. RegPay <=8, OT pay 1 to 4 (hours 9-12), DT pay over 12.

C5: =MIN(A5,8)
D5: =IF(A5>8,MIN(A5-8,4),0)
E5: =IF(A5>12,A5-12,0)

 

[PlumGr8]

These will show the number of hours in each bucket, e.g. RegPay <=8, OT pay 1 to 4 (hours 9-12), DT pay over 12.

C5: =MIN(A5,8)
D5: =IF(A5>8,MIN(A5-8,4),0)
E5: =IF(A5>12,A5-12,0)

Looks like it worked perfect, thanks a lot for the help.