title: Hidden functions in cells
body: <p>I have an Excel form with some hidden functions. I'm not an Excel person so I'm translating it into another program code but I need help in understanding how Excel converts dates and time to make an arithmetic operations.
  Here is an example:</p>
  
  <pre><code> Cell B5: 11/9/12
   Function           
       =B5                =0.1/24           =D2+2415018.5+E2-$B$5/24
   D2: 11/9/12    E2: 0:06:00   F2: 2456240.96 
  </code></pre>
  
  <p>So my problem is that I don't understand how Excel coverts D2 and E2 in the equation:
  D2+2415018.5+E2-$B$5/24 so that I can write it in python code.</p>
  
  <p>Would appreciate some clarification please!</p>