Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
hlines_usacs
Contributor II

Duration between two timestamps in hours, minutes, and seconds

Hello, I have two dates (timestamps) and I want to find the duration between the two in the format of hours, minutes, and seconds. For example: 4 hours, 6 minutes, 3 seconds.

Does anyone know how to do this?

Thanks!

1 Solution

Accepted Solutions

Re: Duration between two timestamps in hours, minutes, and seconds

For the format, you can do this

=Replace(Replace(Replace(Interval(Now() - Today(), 'h@, mm#, ss$'), '@', ' hours'), '#', ' minutes'), '$', ' seconds')

3 Replies

Re: Duration between two timestamps in hours, minutes, and seconds

May be use Interval() function

Interval(TimeStamp2 - TimeStamp1, 'hh:mm:ss')

Re: Duration between two timestamps in hours, minutes, and seconds

For the format, you can do this

=Replace(Replace(Replace(Interval(Now() - Today(), 'h@, mm#, ss$'), '@', ' hours'), '#', ' minutes'), '$', ' seconds')

undergrinder
Valued Contributor II

Re: Duration between two timestamps in hours, minutes, and seconds

Sunny is right, I can only append thatm you can format the string furhter with date function:

=date(interval(date2-date1','s'),'hh mm ss')