Add up the number of hours worked in a week. - Cross-Posted to Mr. Excel

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 attached is a sample of 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.

Cross-Posted on Mr. Excel