Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lin_liu
Partner - Contributor
Partner - Contributor

How to get the number of hours between two time nodes

Hi all

Now I have the following two fields.

p1.png

I need to use ft-joinedtime to figure out how many hours the difference between them is. The script I use now is:

Time (ft-joinedtime,'hh: mm: ss')

but this statement is not counted by days,like this

p2.png

it's only counted by hours.The result I want is like 78:40:05. Who can tell me how to correctly get the result I want?

Best Regards

Lin.liu

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use interval() instead like:

Interval(ft-joinedtime,'hh: mm: ss')

View solution in original post

2 Replies
tresesco
MVP
MVP

Use interval() instead like:

Interval(ft-joinedtime,'hh: mm: ss')
lin_liu
Partner - Contributor
Partner - Contributor
Author

It worked perfectly,thank you!