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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Employee Name [/TD]
[TD]Hours Worked[/TD]
[TD]Total Hours Per Week[/TD]
[/TR]
[TR]
[TD]6/23/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]6/24/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/25/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/26/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/27/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/28/2018[/TD]
[TD]John Brown[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/29/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Employee Name [/TD]
[TD]Hours Worked[/TD]
[TD]Total Hours Per Week[/TD]
[/TR]
[TR]
[TD]6/23/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]6/24/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/25/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/26/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/27/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/28/2018[/TD]
[TD]John Brown[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/29/2018[/TD]
[TD]John Brown[/TD]
[TD]10[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]