todd.debacker Posted September 24, 2007 Share Posted September 24, 2007 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 More sharing options...
todd.debacker Posted September 24, 2007 Author Share Posted September 24, 2007 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 More sharing options...
comment Posted September 24, 2007 Share Posted September 24, 2007 You could calculate each one independently: RegularHours = Min ( TotalHours ; 40 ) ; Overtime = Max ( TotalHours - 40 ; 0 ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6186 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 accountSign in
Already have an account? Sign in here.
Sign In Now