Calculate Gross Pay (Reg & OT)

[Capsaicin Burn]

I am trying to figure out how to calculate the total amount of pay referencing two cells, "Total Hours Worked" and "Hourly Pay Rate". Ideally a single cell would perform all calculations.

If possible I need a formula to calculate/determine:
1. Regular pay vs OT pay (OT = All hours worked over 40)
2. Calculate each accordingly and then SUM
2. Regular time is at pay rate
3. OT is 1.5 times pay rate.

A1 = Pay Rate
A2 = Total Hours
A3 = Gross Pay

Any help would be greatly appreciated! I hope I didn't over complicate my question.

-Jim

 

[SpillerBD]

=min(40,a2*1)*a1+max(0,a2-40)*1.5*a1

 

[Capsaicin Burn]

Outstanding! ray:

That is exactly what I needed. I really appreciate your help!