Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) )
it is base 60