Hi,
I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours.
Example:
<tbody>
</tbody>
This employee is one out of 200, the "Payroll Pay Date" continues to todays date. What I am trying to accomplish is this, for every work week, starting on Monday and ending on Sunday, I would like to calculate that persons hours for that specific week.
So for John Smith, he worked on 07/26/2018 and 07/27/2018, that would be his total hours for the week. His next set of hours for the week would be for 08/02/2018 and 08/03/2018.
I hope that makes sense. All in all, I am trying to break down this excel sheet to show weekly hours worked for each employee, with 34,000 rows.
I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours.
Example:
Company Code | Payroll Name | File Number | Payroll Pay Date | Timecard Hours | PayCode |
AAA | John Smith | 0012345 | 07/26/2018 | 8.00 | Reg |
AAA | John Smith | 0012345 | 07/27/2018 | 8.00 | Reg |
AAA | John Smith | 0012345 | 08/02/2018 | 8.00 | Reg |
AAA | John Smith | 0012345 | 08/03/2018 | 7.50 | Reg |
AAA | John Smith | 0012345 | 08/09/2018 | 8.30 | Reg |
AAA | John Smith | 0012345 | 08/10/2018 | 8.40 | Reg |
AAA | John Smith | 0012345 | 08/11/2018 | 6.60 | Reg |
<tbody>
</tbody>
This employee is one out of 200, the "Payroll Pay Date" continues to todays date. What I am trying to accomplish is this, for every work week, starting on Monday and ending on Sunday, I would like to calculate that persons hours for that specific week.
So for John Smith, he worked on 07/26/2018 and 07/27/2018, that would be his total hours for the week. His next set of hours for the week would be for 08/02/2018 and 08/03/2018.
I hope that makes sense. All in all, I am trying to break down this excel sheet to show weekly hours worked for each employee, with 34,000 rows.