2 Replies Latest reply on Jul 2, 2017 6:35 PM by Michael Lawton

    Summing minutes for workweeks starting Friday through Thursday

    Michael Lawton

      I have minutes of time worked by day by individuals.  I'm trying to calculate hours of overtime per week.  I'm trying to add the minutes for an individual for seven days (always Friday through Thursday), then divide by 60 to get hours.  Then I subtract 40 hours.  The remainder is his or her overtime hrs for the week.  If it is negative I want zero to show.  They I would like to show these weekly overtime hour amounts by individual and District over time; and also create a trend line.  Can't seem to figure it out.

       

      Michael