Counting Negative Times?

[Brad navarro]

Hi,

I have a column of data that represents the difference between two time
values. I have turned on the 1904 date, so for some of the values, I get
negative times, like "-00:05.3"

I need to count these negative times, to report times that have
improved. Unfortunately, using a function like:
COUNTIF(B:B,"<0")
Returns a zero. This happens even if I set the criteria to "<00:00:00" or
even "<time(0,0,0)"

So, does anyone know how I would go about counting the negative time values
in a column?

 

[Bob Phillips]

Brad,

=COUNTIF(B:B,"<0") works okay for me