Help with a calculation

[billi]

i'm looking for a little help with a calculation. I'm sure this is a breeze for most of you. but i have a very limited knowledge of the calculation language.

ok here is is. I want to calculate total hours paid when up to 8 hours is straight pay 8 to 12 hours is x1.5 pay 12 to 14 hours is x2.0 pay

thanks

[Raybaudi]

Try:

Case(

WH > 12 ; 12 + Mod ( WH ; 12 ) * 2 ;

WH > 8 ; 8 + Mod ( WH ; 8 ) * 1.5 ;

WH

)

[comment]

Another way to look at it:

(

Min ( Hours ; 8 )

+ 

Min ( Max ( 0 ; Hours - 8 ) ; 4 ) * 1.5

+

Max ( 0 ; Hours - 12 ) * 2

) * Rate

[comment]

I am not sure this part is what they want:

WH > 12 ; 12 + Mod ( WH ; 12 ) * 2 ;

I think that when hours > 12, you need to split them as:

8 * 1 + 4 * 1.5 + Mod ( WH ; 12 ) * 2

or shortly:

WH > 12 ; 14 + Mod ( WH ; 12 ) * 2 ;

[Raybaudi]

WH > 12 ; 14 + Mod ( WH ; 12 ) * 2 ;

Yes, this is correct.

[comment]

There was another thing that was bothering me re using Mod(), but I couldn't remember what it was. Suppose you have managed to work 24 hours or more...

[billi]

thanks everyone. what a great community