2 Replies Latest reply on Sep 2, 2014 9:36 AM by Phyllis

    How to calculate total hours worked by employee, but sorted by supervisor

    Phyllis

      Title

      How to calculate total hours worked by employee, but sorted by supervisor

      Post

           I run payroll for my company and currently have a table set up that captures a Crew number, employee name, work, start time, end time, daily hours which calculates the hours worked each day, and a total hours field that keeps a running total of the daily hours. This works fine when I sort my data by employee, but I need to be able to sort the data by crew number and then by employee and then get the totals for each employee not the total by crew number. Can't seem to figure out how to do it. Any help?