Results 1 to 4 of 4

Thread: Rota Formulas

  1. #1

    Smile Rota Formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Good morning,

    Try the file attached. Hope this helps.

    Best of luck,
    Attached Files Attached Files

  3. #3

    Red face

    Quote Originally Posted by bgoree09 View Post
    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

  4. #4
    Great to hear .

    Have a good day,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •