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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
4 Replies
tresB
Champion III
Champion III

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

tresB
Champion III
Champion III

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!