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 Addition

i have column time spends values like 0:3:12,0:2:12,0:2:20,0:4:18 and it is in mili second.

i want to add this time value and want to show A:B.

how i can achive this.

Labels (1)
2 Replies
swuehl
Champion III
Champion III

This format gives the time in milliseconds? Could you define the format a bit closer?

I can tell three different parts separated by ':', so the most left part is giving milliseconds? The next two are giving what? Is the number base per part 60 or 100?

If it's more of a commonly used time format, like hh:mm:ss, you could parse these in as time or interval values and just add them using

=interval( sum( FIELD) )

Not applicable
Author

it is base 60