count time brackets

[Peter1973]

I have in A:A date and times ie :

<TABLE style="WIDTH: 77pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=102 border=0 x:str><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl23 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 77pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: silver" width=102 height=17>26-Mar-11 17:30</TD></TR></TBODY></TABLE>

This is in text format I need a formula to look in A:A and count how many of thes times fall between 22:00-06:00.

Any help appreciated

 

[Scott Huish]

=sumproduct(--((mod(a1:a1000,1)>"21:59"+0)+(mod(a1:a1000,1)<"6:01"+0)),--(a1:a1000<>""))