title: VBA "If < Then" function not working correctly
body: <p>I have a macro that sums time values for a week (dblTotal), this total is then added to column 'H' on the last day of the week.</p>
  
  <p>However for one of the weeks the weeks time value only totalled to "0.0972222222222222" (02:20:00)</p>
  
  <pre><code>dblTotal = "0.0972222222222222"
  </code></pre>
  
  <p>The following piece of code is giving me a headache:</p>
  
  <pre><code>    If dblTotal &gt; "1.875" Then
          Range("I" &amp; (i - 1)).Value = dblTotal - "1.875"
          Range("H" &amp; (i - 1)).Value = "1.875" - preTotal
      Else
          Range("H" &amp; (i - 1)).Value = dblTotal - preTotal
      End If
  </code></pre>
  
  <p>When this runs it shows that dblTotal is Greater than 1.875 ? .. </p>
  
  <p>Please let me know if I'm missing something silly here, I've tried using formatting on the values but feel as though I'm shooting in the dark.</p>