Datediff not working on Excel
<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>