Timesheet issue adding hours

Hi all

I have a timesheet which i will attach to this post. I'm finding it difficult to get it to automatically add how many hours each person has been issued with as they are different increments of time depending on where they work. If anyone has any suggestions on how to quickly add up the amount of hours issued to each person, instead of me doing this manually that would be much appreciated. New work schedule 24th Sep.xlsx

Apologies if I didn't explain in great detail.

I have attached a schedule with random shifts allocated as an example.

New work schedule 24th Sep (1).xlsx

At the top of the page where it says week 1 near the list of names id like to calculate how many hours each person would be working in total for week one.

Hopefully that will make more sense.

It does not look like timesheet. Change the template. ecause you will never achieve automatization without changing the hours into date formatting