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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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