11 Replies Latest reply: Dec 12, 2017 6:14 PM by Luis Madriz

# convert number to minute and seconde

Hello,

I have this set analysis in Qlik Sense

the result is 0,55

but i need that be 00:55 minutes

Thanks for help

• ###### Re: convert number to minute and seconde

Hello ZIED,

use the function interval()

And use interval number format in your application

You can also format the output format using interval(sum(x),'hh:mm:ss')

Hope it helps

• ###### Re: convert number to minute and seconde

Hello Luc,

Thanks for help,but when i use the function i have the same result 0,55..

Regards

• ###### Re: convert number to minute and seconde

Here's an little example

• ###### Re: convert number to minute and seconde

• ###### Re: convert number to minute and seconde

I am confused. Your expression is a ratio of times. How would that make sense expressed as a time/interval? It seems to me that it should be expressed as a decimal (0.55) or a percent (55%).

• ###### Re: convert number to minute and seconde

Hi Jonathan,

I was supposing his fields were time format and he'd like to have a total for the delays

• ###### Re: convert number to minute and seconde

total response time / Total answred calls

• ###### Re: convert number to minute and seconde

Hi Zied,

It all depends on the unit of CALLSANSWEREDDELAY. If it's hours then you use this:

If CALLSANSWEREDDELAY is in minutes then you use this:

I hope this helps,

Luis

• ###### Re: convert number to minute and seconde

Hello,

The solution is :

Thansk for all

• ###### Re: convert number to minute and seconde

Good it helped,

Luis

PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

• ###### Re: convert number to minute and seconde

Hello,

The solution is :