Hi, I have in column H a column that represents times. The format is text format and looks like following:
10:00:00
10:00:00
09:00:00
11:00:00
12:00:00
I want to count the occurrences less than equal too 10:00:00. When I try the following it doesn't work:
=COUNTIF(Sheet1!$H$1:$H$10,"<=10:00:00")
It returns zero when should return 3. However if I just do "=10:00:00" , it will return two as expected. Any ideas on how to get this to work?
10:00:00
10:00:00
09:00:00
11:00:00
12:00:00
I want to count the occurrences less than equal too 10:00:00. When I try the following it doesn't work:
=COUNTIF(Sheet1!$H$1:$H$10,"<=10:00:00")
It returns zero when should return 3. However if I just do "=10:00:00" , it will return two as expected. Any ideas on how to get this to work?