"Zb Kornecki" wrote:
I tried this but it It still is not giving me what I need. I'm trying to
count how many people are waiting whenever someone new arrives. I need to
compare each time in col A (Arrival) agaist each pair of times in cols b&c
and count the times that a falls between them.

Think what was suggested earlier was as per your intents and should have
worked. Perhaps you might want to check your data in cols A, C and D for
consistency. These should all be real times.

If it's not a data prob, could you copy n paste some actual sample data &
the expected results in plain text, in response here?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---