Jump to content

Payroll Calculation


This topic is 6115 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6115 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.