Help with rota/roster spreadsheet

Hi

I wonder if anyone can help me. I have a basic knowledge of excel and formulas and this project is abit beyond me

My boss wants me to overhaul the rota at work and put it into a spreadsheet to save her some time.

I have 3 sheets in the workbook. one for the rota, one for the weekly totals for staff and one for the weekly totals for the service users.

What I want is for the total hours that services users have had per day and weekly total in the table on the weekly totals for service users tab. I need the formula to ignore the blank cells.

and I also need a way for the number of hours a staff member has done per week to be calculated and displayed in the table on the weekly totals for staff tab. as I would need excel to find the staff member on the rota and then calculate the hours from the cells above.

Is there a way of doing this? as i am tearing my hair trying to find how to do this as I don't really know what i'm looking for.

I would need step by step instructions really.

Any help would be greatly appreciated.
Thank you

Anyone know how to do this?