Hi!

What are the minimum and maximum times that people will be
present? For example: 6:00 AM to 8:00 PM

Are there any shifts that will span past midnight?

Biff

-----Original Message-----
hi all, thanks for the help i got before but i am still
having trouble, i
need create a function that returns a "head count" from
my staff rota in
excel the rota format is below and each cell is in HH:MM
format, what i need
excel to return is the number of people in the business
between 07:00 and
08:00, 08:00 and 09:00 etc..
help me out, its driving me mad!!!

06:00 1 15:00
09:00 1 15:00
07:00 1 16:00
07:00 1 15:00
09:00 1 15:00
11:00 1 17:00

.