title: Excel formulae to recognise hh:mm
body: <p>I have a cell <code>A1</code> with <code>00:40</code>. I would like to write a formulae to recognise this as a hh:mm.</p>
  
  <p>Apparently this formulae does not work: <code>=if(A1="00:40",1,0)</code>. I get the result as 0, not 1. Is there anyway to get this excel formulae to return as 1?</p>
  
  <p>I have other cells <code>A2=00:42</code>, <code>A3=text</code>, <code>A4=00.50</code>, <code>A6=text</code>, and <code>A7=00.55</code>. Is it possible to have a formulae to extract only the times and ignore the rest?</p>