"COUNTIF" with times

  • Thread starter Thread starter burnsbyrne
  • Start date Start date
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
 
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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Countif time syntax 6
Subtracting 37 hours from a cell containing format [h]:mm 2
calculate total hours/minutes from two time cells 7
DIsplaying negative time values 1
Insert Blank Line and Sort 3
Countif and Time fields 3
Countifs with different restrictions 1

Back
Top