Announcement

Collapse
No announcement yet.

Help needed for a weekend rota - not quite so straightforward.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help needed for a weekend rota - not quite so straightforward.



    Hi, all.

    I really hope someone can help with this. I have posted in a few forums and I've had no responses, so I'm not sure if what I'm asking for is possible or not.

    I am creating a weekend working rota. We have around 30 staff covering weekend working. They work on 4 different contracts, but can only work on any particular contract if they have done so in the last three months (else they require refresher training). If a name is entered for a contract that the worker has not covered in the last three months, I need an error that says that name cannot be entered.

    The workers also have the option to be paid for the day they work, or they can take a day in lieu. I need to count up the amount of days taken in lieu each month so we can see how many lost days we have during the week over each month.

    I hope I am making sense.

    I have attached a sample spreadsheet but I've no idea if I would need a completely different layout to get the results I am asking for. I would really appreciate some help with this as the weekend working has already begun.

    weekend_working.xlsx

    Thanks so much.

    http://www.excelguru.ca/forums/showt...traightforward
    http://www.excelforum.com/excel-prog...55#post3288255
    Last edited by Carrie_Smattick; June 24th, 2013, 07:00.

  • #2


    Re: Help needed for a weekend rota - not quite so straightforward.

    My apologies for the cross-posting. I have edited the post above with links to the other posts.

    Comment

    Working...
    X