subtract datetime in excel
<p>I'm trying to subtract two dates in two separate columns in excel, to find time difference. in h:mm format. The source format is the following.</p>

<p>11/18/2014 9:42:39 AM - 10/8/2014 12:17:13 PM</p>

<p>I have updated the columns to a date with the correct format.</p>

<p>When I subtract the two columns from eachother i get the following hh:mm value. </p>

<p>21:25 </p>

<p>It seems to me that the calculation is not taking the dates into account.</p>

<p>What can i do to correct this?</p>