hi
shift cover 24 hours of a day (just to make it easy, lol)
although generally, most morning starters ar at 6am last finishers are 11pm,
however there are four that start 10pm and finish at 7am

does this mean you have an idea???

nick

"Biff" wrote:

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

.