Payroll Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am not going to be all lengthy in the explanation, it would be easier to
show. This is for payroll. I have a form that has Employee Name, Start
Time, End Time. On the form itself, I wrote a box that a calculated
expression and an update query updates this info in that same table as hours
worked. It looks like this:

=(((([End Time]-[Start Time])*24)*60)/60), this gives the total hours - the
time is formatted as 08:00 AM.

Now to the question. On the report I have the total hours summing and
multiplying themselves by the employee's hourly rate. The problem is, the
employee may exceeed 40 hours per week giving me the wrong total. Is there
an IFF statement that would resolve this on the report. I would prefer to
have it calculate on the form so I can do reporting on payroll.

Sincerely,

Rainmain
 
You can use an IIF to force the value to 40 if it is greater than 40.

IIF(SomeCalculation > 40, 40, SomeCalculation)

Replace SomeCalculation with your calculation -- Sum(HoursWorked) -- or whatever
you are using.
 
Back
Top