Hi,
I have a spreadsheet with employees and hours worked for each day. However, each employee may have multiple lines for their hours. I want to be able to show only one line per employee, per day, with totals hours worked. This way I can see the Overtime. I want to do this in a Pivot table. Or, if needed, to complete in the spreadsheet prior to creating the pivot table. This spreadsheet currently has more than 2k lines for all employees that worked this project.
I have a spreadsheet with employees and hours worked for each day. However, each employee may have multiple lines for their hours. I want to be able to show only one line per employee, per day, with totals hours worked. This way I can see the Overtime. I want to do this in a Pivot table. Or, if needed, to complete in the spreadsheet prior to creating the pivot table. This spreadsheet currently has more than 2k lines for all employees that worked this project.