I'm trying to put together a set of worksheets for work that show up who's
on a tea break at a given time..

The project has 3 tabs at the bottom to choose either
DUTIES,,SHIFTS,,BREAKS..

The first 2 DUTIES and SHIFTS work fine....but what i'm trying to do now is
get the BREAKS sheets to display the day in 15 minute segments and each 15
minutes display the people who are on a break at that time.

The DUTIES screen scrolls down to show each day of the week we are open (Mon
to Sat)

Row B has all the names of the staff and goes from cell 6 down to cell 31.

The breaks are shown in Time format in columns H to K and again in cells 6
to 31.

Is there a way that I can get the BREAKS sheets to check the times on the
DUTIES sheet and automatically insert them into the relevant time slots.


I can send the file if needed.

Many Thanks

Dave B