Duration Calculation

[abTech]

 I have table that contains this tow columns i want to calculate the duration time in a new column the both column are timestamp data type 

[MarcoWedel]

Interval(EndDate-StartDate)

[abTech]

Thanks but it try it and showing up like these which i think it's not correct.

is there any other way to do it. thanks for your participation .

[Kushal_Chawda]

@abTech  How would you like to have your duration? In hours?

[abTech]

hours and minutes

[BrunPierre]

Retry @MarcoWedel 's suggestion with a format.

Interval(EndDate-StartDate, 'hh:mm')

[snibrahim1993 · Accepted solution]

Hi @abTech 
Please try like below expression

Interval(EndDate - StartDate, 'hh:mm')
Or
Interval(Timestamp(EndDate) - Timestamp(StartDate), 'hh:mm')

[abTech]

this also not working 

[snibrahim1993]

@abTech  It's showing hours and minutes correctly, what's your expected output?

Please share

[abTech]

it's should 6 mins the duration!