Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: We have made updates to resolve a Page Not Found error. If you still get this error, please let us know in the Community Corner.
Highlighted
rsingh43
Contributor

Duration between two dates

Hi All,

I have two dates and require the duration between these dates in hours and minutes, can anyone help as to how this is done?

IDArrivedDeparted
101-01-2018 10:00:0005-01-2018 09:15:00

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.

Thanks

Tags (3)
2 Replies
YoussefBelloum
Esteemed Contributor

Re: Duration between two dates

Hi,

try this:

=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

undergrinder
Valued Contributor II

Re: Duration between two dates

Hi Raman,

=Interval(Arrived,Departed,'hh:mm:ss')


G.