title: Excel IF Statements & Formulas
body: <p>I am importing into excel timestamps in the format <code>YYYY-MM-DD HH:MM:SS.sss</code> into column A of a new spreadsheet.  I am trying to calculate the difference between two times.</p>
  
  <p>So in column B I have the formula <code>=RIGHT(A1,6)</code> which gets the <code>SS.sss</code> value.  In Column C I am taking the values away from each other - <code>=B2-B1</code>.  This correctly calculates the gap between the two values.</p>
  
  <p>What I want to do now, is create an IF statement <code>=IF(C2&lt;&gt;0.02,"","Error")</code>, to determine if the time gap is not the value is it supposed to be.</p>
  
  <p>The problem is, that this IF statement always is evaluated as <code>Error</code> instead of the blank cell, even if the value in column C is 0.02.</p>
  
  <p>Does anyone know why this might be happening?</p>