Calculations

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I have a report that lists Total Hours Worked, Less
Standard Hours. OverTime and an Overtime %.
Standard hours will always be 40.
If a normal work week = 40 hours but a person only puts in
32, how do I create a calculation in a text box to say the
following:
If total hours worked is less than 40 then OverTime = 0
Else if Total hours worked is more than 40 then take total
hours worked -40 (for O.T.) /40 to get the overtime %?
Is this possible?
 
An ideal IIF application:
[OvertimePercent]=IIF([TotalHours]<40,0,([TotalHours]-
[StandartHours])/40)
Hope this helps.\Fons
 
Thank you - I'll give that a try!
-----Original Message-----
An ideal IIF application:
[OvertimePercent]=IIF([TotalHours]<40,0,([TotalHours]-
[StandartHours])/40)
Hope this helps.\Fons
-----Original Message-----
I have a report that lists Total Hours Worked, Less
Standard Hours. OverTime and an Overtime %.
Standard hours will always be 40.
If a normal work week = 40 hours but a person only puts in
32, how do I create a calculation in a text box to say the
following:
If total hours worked is less than 40 then OverTime = 0
Else if Total hours worked is more than 40 then take total
hours worked -40 (for O.T.) /40 to get the overtime %?
Is this possible?
.
Click to expand...
.
Click to expand...
 
Back
Top