"vldavis809" wrote
in message ...

I would like to count how many cells are greater-than and less-than a
certain time-frame. I'm using military times formatted in custom as
"hhmm"

Example:

A
1230
1140
1834
0016
0348


Ultimatly would like to end up with:

0600-1759=2


=SUMPRODUCT(--(A1:A100=600),--(A1:A100<1800))


1800-0559=3 (realizing this time frame goes into the next day)


=SUMPRODUCT(--(A1:A100=1800),--(A1:A100<=2399))+COUNTIF(A1:A100,"<"&600)


0000-0559=2


=COUNTIF(A1:A100,"<"&600)