Try:

=MIN(40,SUM('week-1:Week-5'!I12))*Regular Rate

=MAX(0,SUM('week-1:Week-5'!I12)-40)*Overtime Rate

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Louie" wrote in message
...
Hello, I need to generate a formula to add 5 weeks of work x hourly rate
but
the total of 5 weeks is larger than 40 hours, how can I take away only the
40
hours.
here is the formula I have.
=SUM('week-1:Week-5'!I12)
this comes back with 48.25 hours and I need to get only 40 to multiply x
regular time.
and another one for the overtime.
thank you in advance for your help.

--
Louie