TWO OR MORE TOTALS FROM THE SAME EMPLOYEE
I am looking to create a report that will give the total hours worked at certain rate. all of our employees work different events and some events pay $8, some pay $11, supervisors get pay $14, $15 or $16 but they can also be pay $8 or $11 if they are working a non supervisor position. they work all these shifts in the same pay period. I am looking to automate the way we submit payroll. Instead of doing it manually i want to submit it in a spread sheet but i need to have a separate total of hours for each rate. For example if "Mike Johns" worked 30 hours on a pay period i would like to know how many total hours he work at $8, at $11 or at $15. I tried to do a summary but that won't give me a separte total. Can someone give me a hand?!
Thank you in advance!