Rota Formulas

Stevie

New member
Joined
Sep 27, 2013
Messages
2
Reaction score
0
Points
0
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
 
Good morning,

Try the file attached. Hope this helps.

Best of luck,
 

Attachments

  • Worker_Hours_sample.xlsx
    9.5 KB · Views: 20
Back
Top