18 Replies Latest reply: Oct 31, 2011 9:03 AM by Marc Livingston RSS

    Trying to show overtime vs standard hours per week. Need to calculate based on hours per employee

      I am trying to show a chart that shows Hours per week, and Over time hours per week.

       

      I am running into a problem where I need to tell the expression to take a summary for the week based on the employee, and if that number is over 40 to subtract 40 to get the over time hours.

       

      How can I tell it to do this?

       

      Example:

       

      Employee       Hours per week

       

      1                    30

      2                    50

      3                    20

      4                    60

      5                    40

       

      The correct overtime for this example is 30. Standard hours is 170.

       

      Calculating Standard as 40hr/employee would show 200 standard hours and 0 over time.