title: How to find difference between two dates with time in custom format in hours?
body: <p>Cell A1 has date 06/22/2016 11:17:00 AM IST and cell B1 has date 06/22/2016 11:38:00 AM IST</p>
  
  <p>Both this dates are in custom format.</p>
  
  <p>I have to find the difference between these two dates in hours.</p>
  
  <p>For this i am using below formula
  C1=(LEFT(B1,22)-LEFT(A1,22))*24</p>
  
  <p>Now i am getting answer 0.35
  This is difference between two dates in hours.
  But this is wrong. Answer should be 0.27</p>
  
  <p>Don't know what is going wrong.</p>
  
  <p>Please help.</p>