title: How to calculate elapsed time in seconds in VBA?
body: <p>I have 2 strings, strStartTime and strEndTime.</p>
  
  <p>strStartTime = "12:32:54"
  strEndTime = "12:33:05"</p>
  
  <p>I want to find out how many seconds elapsed between strStartTime and strEndTime so I did this:</p>
  
  <pre><code>Dim dtDuration as date
  dtDuration = DateDiff("s", CDate(strStartTime), CDate(strEndTime))  
  </code></pre>
  
  <p>The result I get is dtDuration = "#1/10/1900#" in the Locals watch window.</p>
  
  <p>Why does this happen?  How do I get dtDuration to equal 11 for the 11 seconds that elapsed between the start and end times?</p>