Duration

[Anonymous]

Hi, 
First, when I imported my Excel data I had to set the Data Type as Time.
I was receiving an error when I wanted to set it as Duration. 
Current Duration Format: 13:30 (hh:nn)
I have the Start Time e.g 15:05 and End Time e.g. 16:10
I have tried DAX DATEDIFF but the return came back as 00:00

I am unable to create valid Visualisation for the Time Duration. 

[Anonymous]

Thank you @amitchandak 

Unfortunately, this formula doesn't work for me. The result is 00:00
my formula:
TimeDuration = DATEDIFF('FACT TABLE'[Start Time],'FACT TABLE'[End Time], second)

[amitchandak · Accepted solution]

@Anonymous , You will not be able display duration on y axis

But this column should work

datediff([start time], [end time],second)