OK. This is a tricky one (I think!).

Where I work we have a team of around 15 people, some of whom work part-time.
Each worker has to spend time on a duty rota as either Duty 1, Duty 2, or
Visiting Officer.

What I would like to do is have an excel spreadsheet with a month per sheet
across a year (for example €“ this might not be the best way to tackle the
problem).

I would like to be able to enter the names of the team members with the
hours/days they work (to take account of the part-timers and be able to cope
with changes to the team) and then for some clever mathematical equation to
work out the rota for me.

Each member of the team would need to do their fair share of days on duty
with each worker doing Duty 1, Duty 2 and Visiting Officer days spread across
a month. Of course, it may be that some workers do more duty days on some
months but this should be balanced out across the year as much as possible.

Is it possible?