Help with counting formula

Sheet 1, Row 1, Column 2 - opening hours divide into
15min segments. B1 -
08:00, C2 - 08:15, D2 - 08:30, and so on.

Sheet 2 , Columns 1 and 2 - a list of each agents break
times. Column A -
Start time (eg 10:00) and Column B - End time (eg 10:30).

Sheet 1, Row 2, Column 1 - summary titles. (eg Cell A2 -
"Morning Break").

Problem: I need to summarise the number of agents away
on, say, "Morning
Break" per 15 min segment.
So, B2 must count the number of people on "Morning Break"
at 08:00, B3..the
number of people of people on morning break at 08:15, and
so on, based on the
list of start/end times found on Sheet 2.

=Countif(Sheet2!A:A, Sheet1!B1) inserted into Sheet 1
cell B2 is not
sufficient as it counts the number of people whose breaks
begin at 08:00 only.

Thanks in advance.

Ian
..

"Ian":

> Sheet 1, Row 1, Column 2 - opening hours divide into
> 15min segments. B1 -
> 08:00, C2 - 08:15, D2 - 08:30, and so on.
>
> Sheet 2 , Columns 1 and 2 - a list of each agents break
> times. Column A -
> Start time (eg 10:00) and Column B - End time (eg 10:30).
>
> Sheet 1, Row 2, Column 1 - summary titles. (eg Cell A2 -
> "Morning Break").
>
> Problem: I need to summarise the number of agents away
> on, say, "Morning
> Break" per 15 min segment.
> So, B2 must count the number of people on "Morning Break"
> at 08:00, B3..the
> number of people of people on morning break at 08:15, and
> so on, based on the
> list of start/end times found on Sheet 2.
>
> =Countif(Sheet2!A:A, Sheet1!B1) inserted into Sheet 1
> cell B2 is not
> sufficient as it counts the number of people whose breaks
> begin at 08:00 only.
>
> Thanks in advance.
>
> Ian
> ..
>
> you can use data / pivot table report instead of using countif formula.
it is more usefull trust me..
>