title: EXCEL VBA DATETIME subtraction
body: <p>This question was asked before and i tried to implement that solution but I can't get it to work
  THis is basically what I am trying to achive
  To subtract datetime values to get the number of total hours EVEN if it is beyond a day then the value I would like to display is 36:03, this is in the format [h]:mm, tks, below is the VBA code I am trying to implement</p>
  
  <pre><code> Sub dateissue()
  Dim startdate As Date, enddate As Date
  Dim doublevar As Double
  
  enddate = "13/2/2014 08:10:00"
  startdate = "12/2/2014 18:10:00"
  
  doublevar = enddate - startdate
  Range("D3").Value = Format(doublevar, "[h]:mm")
  
  
  End Sub
  </code></pre>
  
  <p>My result in D3 is always <strong>:12</strong>
  any reason why</p>