title: Convert time to number and then match it to a another number
body: <p>My problem is that I'd like to match time (hours) to a column with general numbers to get some values out from some other cells.</p>
  
  <p>I managed to convert my date-time values to just the number of the hour using:</p>
  
  <pre><code>=TEXT(TIME(HOUR(B5),MINUTE(B5),SECOND(B5)),"h")
  </code></pre>
  
  <p>but when I try to match this to, for example, the number 10 it responds with <code>#N/A</code>.</p>
  
  <p>How should I solve this?</p>