Rota problem

[jais_davies123]

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

[jais_davies123]

Just double checked and i can't change the design at all

[Toonies]

here is a Timesheet that may be of use to you, it is similar design and easy to use.

If you need further help simply ask.

Timesheet v3.xls

[jais_davies123]

Thanks for the relay, the timesheet is a lot better then the one my company is using but sadly i cant edit the design at all..is there any way that my rota could add up the hours in the total cell?

or is the 8:00-13:00 method a no go?

thanks

[jais_davies123]

The only way I can think of doing it is by putting a Column between the hours...but I would still have to manually count the hours and enter that in that column then add them all up to the total cell.

[Toonies]

Hi this is the best that I can come up with, it uses helper hidden columns.

It does what you want and ignores Text if inputted in the cell.

you might get a more simpler Formula from a more experienced member.

ROTA1.xlsx

[jais_davies123]

Toonies,

Thank you SO much this is PERFECT

thank you thank you thank you