Calculations

[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?

 

[Guest]

An ideal IIF application:
[OvertimePercent]=IIF([TotalHours]<40,0,([TotalHours]-
[StandartHours])/40)
Hope this helps.\Fons

 

[Deb]

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?
.

.