title: Datediff not working on Excel
body: <p>I am trying to write a DAX query and it is always returning me an error.</p>
  
  <p>What I want to calculate hours different 2 columns -</p>
  
  <p>So I have --</p>
  
  <ul>
  <li><code>StartTime</code> 2015-03-02 09:00 </li>
  <li><code>EndTime</code> 2015-03-02 18:00</li>
  </ul>
  
  <p>So I want to calculate the hours different between two ---</p>
  
  <pre><code> DATEDIFF([StartTime]; [EndTime];HOUR)
  </code></pre>
  
  <p>but this query is not working !</p>
  
  <p>Do anyone knows where I am making the mistake !</p>