Payroll Calculation

[todd.debacker]

Hopefully this isn't too hard, here is what I am trying to do:

I am creating a payroll section in my database. For each day of the week you enter the hours worked that day. Then on the side of this table I want to have fields that display the following data:

- Regular Hours Worked

- Overtime Hours Worked (Any hours over 40)

- Total Hours

- Total Pay

I can figure out Total Hours (simply sum all hours), but beyond that I am lost on how to do the functions.

Regular Hours should be the sum of everything, but limited to displaying a max of 40 hours.

Overtime hours should show anything over 40 hours

Total Pay (I think I have this one) is a calculation of the regular hours * regular pay + overtime hours * overtime pay

So what I need to figure out is how to do regular hours, and overtime hours. What functions or statements do I need?

Thanks

-todd debacker

[todd.debacker]

Alright, nevermind, I figured it out.

If anyone is interested, here is what I did:

- Totaled all hours into "Total Hours"

- Case formula for "Overtime Hours"

Case (Total Hours >40;Total Hours - 40)

- "Regular Hours Worked" = Total Hours - Overtime Hours

It is simple enough, the problem I had was trying to figure out regular hours then the overtime hours based on that, it seems much easier to work backwards.

-todd debacker

[comment]

You could calculate each one independently:

RegularHours = Min ( TotalHours ; 40 ) ;

Overtime = Max ( TotalHours - 40 ; 0 )