I have a monthly rota in excel, that has quite a few different shifts.

I need the total number of hours to be calculated for each person but I don't have a great knowledge of Excel so finding this difficult to get it to work.

I have a sheet with the rota and then a sheet with a list of the different shifts and the number of hours each shift totals. I just need the calculation to appear in a column on the rota.

Is there anyone that can help? Even if I can email the rota to that person in order to show what I mean??

Any help would be greatly appreciated.

Thank you