Using multiple payrates

[allong]

Hello, we have a report that has mutiple payrates. This also give us overtime hours. There is an entry for each payrate on an employee. Most employees have two payrates. How do I add up the hours for each payrate together to determine the overtime for an employee. And how do I determine the overtime rate to apply to the overtime hours.

 

[cghoga]

I'm not sure what your field names are, but try something like the following:

TotalPay = ([RegularPayRate]*40) + (([TotalHoursWorked]-40)*OTPayrate)

hope this helps you.

 

[allong]

Thanks cghoga, but here is the layout of my report. It is running off of a table query. The report looks like this:

Name PayrollID Hours Payrate OTHours
Jane Doe 22222 40 20
Jane Doe 22222 3.5 11.75
Jane Doe 22222 2 19

I need to get the hours over 40 for my overtime hours. If the payrate is not the same the hours does not automatically total. I need for the report to look like this:

Name PayrollID Hours Payrate OTHours OTRate
Jane Doe 22222 40 20 3.5 15.87
Jane Doe 22222 2 25.50

Is this possible without doing a lot of programming?