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:-
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
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