Call Duration Format Calculations in Qlikview

[#1]

Hi.

I'm trying to get the durations of calls right for our callcentre model. The way we get Callduration from the database is eg. 00:11, 14:56 etc. When i do a sum of the call duration in an expression it doesn't come right as you can see below. It seems like such a simple thing but i've tried everything and it doesn't look right.

I've also created a live call duration 'tick over' (below) - I've tried to say DD:HH:MM:SS

But because the format in which it comes in (mm:ss), i don't know if it is right, it never shows the seconds which i know t should.

Please could someone help me with this.

P.S. Sorry if this has already been brought up.

[daniel_wennstro]

You can use interval() to do that.

if you get sum(Duration) and duration are in format "interval" (make the formatting in the script). then you will be able to get duration of more than 24 hours, and also use a format like DD:hh:mm:ss or D hh:mm:ss.

Note, if you got the call length in seconds, you will have to divide it by 86400 to get it in time format: intervall([Duration seconds] /86400)

Br Daniel