"COUNTIF" with times

B

burnsbyrne

I have three column of times formatted "13:30". The third column is the
result of subtracting the first two. I would like to find how many of
the values in the third column are less than one hour or "<1:00". I
tried to use

=COUNTIF(C2:C60,"<1:00")

but I got an answer of "00:00" when I expected 40-50. Does anybody
have a solution?
Thanks in advance.
Mike
 
J

JE McGimpsey

First, the format of the times in your column doesn't matter - just the
stored value.

Format your COUNTIF() cell as General. Since XL stores times as
fractional days, an integer will be interpreted as midnight, or "00:00".
 
Top