mrsbrannon
Board Regular
- Joined
- Mar 7, 2018
- Messages
- 61
Hello all,
I am trying to find a formula to add up how many hours an employee worked in each work week. There is lots of data on my sheet, but below are the columns that I believe will be pulled from. I'm fine with adding a helper column (shown in my example as the "total hours per week" column. Note, our work weeks are Friday to Saturday, so I need that factored in during the summing. It would also be nice if I can get the data to just appear once per name. Let me know if none of that makes sense.
<tbody>
</tbody>
I am trying to find a formula to add up how many hours an employee worked in each work week. There is lots of data on my sheet, but below are the columns that I believe will be pulled from. I'm fine with adding a helper column (shown in my example as the "total hours per week" column. Note, our work weeks are Friday to Saturday, so I need that factored in during the summing. It would also be nice if I can get the data to just appear once per name. Let me know if none of that makes sense.
Date | Employee Name | Hours Worked | Total Hours Per Week |
6/23/2018 | John Brown | 10 | 60 |
6/24/2018 | John Brown | 10 | |
6/25/2018 | John Brown | 10 | |
6/26/2018 | John Brown | 10 | |
6/27/2018 | John Brown | 10 | |
6/28/2018 | John Brown | ||
6/29/2018 | John Brown | 10 |
<tbody>
</tbody>