Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
For the format, you can do this
=Replace(Replace(Replace(Interval(Now() - Today(), 'h@, mm#, ss$'), '@', ' hours'), '#', ' minutes'), '$', ' seconds')
May be use Interval() function
Interval(TimeStamp2 - TimeStamp1, 'hh:mm:ss')
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')