Overtime Calculation

I have created a report for editing labor. I need to tweak my overtime calculation.

IIF(LaborHoursTotal > 40, LaborHoursTotal - 40,0)

If the report is run over a period of a year or even a month, instead of just a week, the overtime is miscalculated. Any suggestions?

Wendy Pursche
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323

[Non-text portions of this message have been removed]