Discussion board where members can get started with Qlik Sense.
I have two dates and require the duration between these dates in hours and minutes, can anyone help as to how this is done?
I would like to show for the above the numbers of hours and minutes between product arriving and then departing the warehouse.
If this is not possible just getting the numbers of days would work.
=Interval(Timestamp#(Departed,'DD-MM-YYYY hh:mm:ss')-timestamp#(Arrived,'DD-MM-YYYY hh:mm:ss'),'HH MM')
it will give you 95 hours and 00 minutes