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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.

2 Replies
swuehl
MVP
MVP

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