
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Duration Calculation
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @abTech
Please try like below expression
Interval(EndDate - StartDate, 'hh:mm')
Or
Interval(Timestamp(EndDate) - Timestamp(StartDate), 'hh:mm')
If this resolves your Query please like and accept this as an answer.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Interval(EndDate-StartDate)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 .

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@abTech How would you like to have your duration? In hours?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hours and minutes

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Retry @MarcoWedel 's suggestion with a format.
Interval(EndDate-StartDate, 'hh:mm')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @abTech
Please try like below expression
Interval(EndDate - StartDate, 'hh:mm')
Or
Interval(Timestamp(EndDate) - Timestamp(StartDate), 'hh:mm')
If this resolves your Query please like and accept this as an answer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this also not working

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@abTech It's showing hours and minutes correctly, what's your expected output?
Please share
If this resolves your Query please like and accept this as an answer.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it's should 6 mins the duration!

- « Previous Replies
-
- 1
- 2
- Next Replies »