Referencing multiple time ranges on excel

Hi,

Thank you so much for your time, I really appreciate it!

I am doing this to help the salaries department in my hospital who are currently doing this manually on a piece of paper. I am one of the employees here and have nothing to do with salaries but thought it would be great to digitize the overtime sheet.

In order for them to take it I need to make sure it looks the smae as what they have now or they wont accept it, Its a nightmare!

What I have created is an exact copy apart from the columns to the right which I have added.

Is there any way of making it work within the constraints of the workbook I have sent originally?

Again, I am so grateful for all your help with this!

Thank you