Excel Staff Hours Worksheet...

[DB]

I've created an excel worksheet that I use to hand out duties at work to our
20 staff.......I have most things on it such as start times, finish times,
breaks,lunches etc....

I'm trying to balance things up over the breaks and lunches but it's getting
complicated... I want to try and get an even distibution of staff over all
breaks....

My work sheets have all breaks but I am hoping that there might be an easy
solution to what I want...I have everyones breaks listed.....for
example.....
column F shows morning
breaks....F1...9:30....F2....9:45......F3....10:45....F4...11:15.........

Is there a way of showing on a row.......how many people are on a
break........i.e. .if 3 people are on a break at the same time......


If it helps..I can send my excel sheet.............

All help appreciated..

Cheers

Dave

 

[DB]

Many Thanks to all who offered advice.....

Special Mega Thanks must goto Sandy Mann from Perth/Scotland who gave me
loads of advice and re-wrote most of what I had started.
People like Sandy show us exactly why the Newsgroups are so superb.

Dave