How to calculate total hours worked by employee, but sorted by supervisor
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?