Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum up time

I have a CSV file containing activities where each activity has a time associated with it in minutes and seconds (two separate columns). I want to sum up the time for all the activities and the total time will be several hundred hours and should be shown as hhh:mm:ss. I started to do a lot of Div and Mod of the sums of minutes and seconds, respectively, to get the total sum, but isn't there some easier way to accomplish this?

1 Reply
Not applicable
Author

Hi,

You probably may fin the answer in the following thread.

http://community.qlik.com/message/66084#66084

Regards,

Gerrit