Hi all,

Sorry if this is in the wrong place.

I'm new to excel and rotas.

The company i work for have hand wrote rota for years but now have changed to putting them on excel.

The problem i have is i can't seem to work out the formula to add the hours up and put them in the total.

The rota has to stay like it is i can't change the design.

I have made a simple of the rota to show you guys.

If anyone can help that would be great.

Thanks.

ROTA.xlsx