title: Excel SUMPRODUCT with ISNUMBER and TIMEVALUE and LEFT to meet criteria
body: <p>In <code>Cell D$3$:D$38$</code> I have</p>
  
  <pre><code>## Heading ##
  Thu Oct-05
  Off
  Off
  Off
  Maternity
  Off
  Off
  Off
  Off
  Off
  Off
  VACATION
  04:00-16:00
  04:00-14:00
  05:00-14:00
  05:00-14:00
  06:00-16:00
  06:00-15:00
  07:00-17:00
  07:30-16:30
  07:30-16:30
  08:00-17:00
  08:00-17:00
  08:00-18:00
  08:00-17:00
  08:00-18:00
  09:00-18:00
  09:30-18:30
  10:00-19:00
  10:00-19:00
  10:30-19:30
  10:30-19:30
  11:00-20:00
  12:00-22:00
  13:00-22:00
  13:00-22:00
  15:00-22:00
  </code></pre>
  
  <p>I used the formula</p>
  
  <pre><code>=SUMPRODUCT(--(ISNUMBER(TIMEVALUE(LEFT($D$3:$D$38,5)))))
  </code></pre>
  
  <p>to successfully obtain the result of 25 cells with number in the specified range but when I try to add a criteria like:
   <code>&gt;=ISNUMBER(TIMEVALUE(B44))</code> and <code>B44</code> is <code>4:00 am</code> and the second criteria <code>&lt;=ISNUMBER(TIMEVALUE(c44))</code> <code>B44</code> is <code>5:00 am</code>
  I'm not able to get the result I should that's: <strong>2</strong></p>
  
  <p>Do you know why it is not working the way it should?
  Thank You</p>