AnsweredAssumed Answered

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

Question asked by Phyllis on Aug 28, 2014
Latest reply on Sep 2, 2014 by 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?

Outcomes