Hi all,

I have a list of times of which i need to know how many are after 7pm and before 7am. I have used the following statement but its returning 0 so i am assuming that im wrong:

=COUNTIF(RANGE,">07:00:00<19:00:00")

Its cleary wrong..but does anybody have any ideas on this one? Thanks,

Phil