To add up bar or kitchen hours you can use the SUMIF() function. It will add numbers in one column, if cells in the corresponding row in a different column match a criteria.
I could have used this:
This would have given the total kitchen hours in the first week's hours column (cells D3 to D9)
The problem with this is that the formula will fail if the pay rate changes.
What I have done is use columns F and K to flag whether the hours were Kitchen or Bar.
I used this formula in cell F3:
This works on the basis that there are two pay rates and if the rate in cell C3 is as large as the largest in column C, it must be the Kitchen rate, and displays "K".
If it's not the highest rate, it displays "B".
If the hours in column D are zero/empty cell it displays a blank cell.
If you use 0 for no hours or leave the hours cell empty, the OR function should return TRUE for 0 or "".
This isn't perfect - it would fail if all shifts were Bar shifts that week
Also if the pay rate changed mid-week it would fail.
I am sure that there could be variations on this formula to make it more robust, but I offer it as a starter
Drag the formula in cell F3, down to F9
Copy D3 to F9 and paste into K3 to K9
Now the hours:
In cell B12 enter this:
Format the cell as [h]:mm
The formula will sum all the hours where there is a "B" in column F
The format allows hours over 24 to display as hours as opposed to being converted into days.
In cell B13 do the same, but the formula looks for "K" in column F
In cell B14 I entered this formula:
Again format as [h]:mm
I used this longer formula as a way of testing that the two COUNTIF formulas had captured all the hours. If not you get "Error" displayed.
In cell B15 enter
and format as a number with two decimal places.
Copy B12 to B15 and paste into G12 to G15
Hope this helps.