Hi,

I wonder if anyone could make any pointers, or give any tips regarding
an issue I am currently trying to sove.

I currently have nine members of staff, and five specific duties which
need to be carried out throughout the day. Some people should do
certain duties more than others, but they should always be done,
taking into consideration lunches, breaks, or days when the staff
member doesn't work etc.

At the moment I make a timetable to reflect this, but it is a
laborious process, and I would like to automate it if I can, maybe a
spreadsheet which would organise the duties between each person fairly
depending upon the above criteria.

Can anyone suggest ways in which this may be possible (if it is) and
how I may achieve it?

Many thanks,
Peter Bancroft