Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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!