Rota Formulas

[Stevie]

HI

I work in an agency where i have to add up staffs hours. I use the rota to do this. Is there a formula that i can put in place which automatically adds up the hours for each member of staff? for example:-

Client	Time in mins	Monday	Tuesday	Wednesay
Mr A	0.5	Joe	Joe	Adam
Mr B	0.75	Joe	Joe	Adam
Mr C	0.5	Adam	Joe	Adam
Mr D	0.5	Sally	Sally	Joe
Mr E	1	Sally	Sally	Joe
Mr F	0.75	Joe	Adam	Sally

What i want it to do is tell me how many hours Adam has worked, Joe has worked and Sally has worked over these day. Is there a formula for this?

Thanks

[bgoree09]

Good morning,

Try the file attached. Hope this helps.

Best of luck,

[Stevie]

Good morning,

Try the file attached. Hope this helps.

Best of luck,

Thank you ever so much you have made me a very happy bunny

[bgoree09]

Great to hear .

Have a good day,