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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time summation

How to find the sum of time entries in list box

thanks

SK

4 Replies
tresesco
MVP
MVP

Please take a bit more pain to explain better about your requirement. Refer,

How to Get Answer to Your Question

Not applicable
Author

my data is as follows : 

00:03:10

01:03:10

00:44:40

i want to find sum of above time duration fields

tresesco
MVP
MVP

Is this what you want?

Expression: Time(Sum(YourField), 'hh:mm:ss')

PFA

Not applicable
Author

Hi Sagar,

You can use as below:

Test:

Load * Inline [

Data

00:03:10

01:03:10

00:44:40

];

Then to calculate Sum use : Time(Sum(Data), 'hh:mm:ss')

Hope this helps!