title: Countif does not work with hours and/ or dates
body: <p>Hi I have data inside 3 columns:</p>
  
  <p>A. Destination (es. LosAngeles)
  B. Carrier      (es. Ups)
  C. Shipment Time (es. 4:00)</p>
  
  <p>The time used is the 24h time without Am/Pm</p>
  
  <p>I need to do a countif  to know how many shipments we have at a specific time.</p>
  
  <p>Tried with:
  =COUNTIF(A1:A100,">="&amp;TIME(8,30,0))-COUNTIF(A1:A100,">"&amp;TIME(9,0,0)
  Result 0</p>
  
  <p>Tried with:
  =COUNTIFS(A1:A100,">=8:30",A1:A100,"&lt;=9:00")
  Result 0</p>
  
  <p>Tried with:
  =COUNTIF('sheet1'!I:I,"&lt;="&amp;TIME(4, 0, 0))
  Result 0</p>
  
  <p>Any help?
  Thank you in advance.</p>