B
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?
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?