Good morning,
Try the file attached. Hope this helps.
Best of luck,
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,
Great to hear.
Have a good day,
Bookmarks