# Qlik Sense Deployment & Management

Contributor III

## 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

1 Solution

Accepted Solutions
Contributor III

## Re: convert number to minute and seconde

Hello,

The solution is :

Thansk for all

11 Replies
New Contributor II

## 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

Contributor III

## 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

New Contributor II

## Re: convert number to minute and seconde

Here's an little example

MVP

## 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%).

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
New Contributor II

## 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

Contributor III

## Re: convert number to minute and seconde

total response time / Total answred calls

MVP

## Re: convert number to minute and seconde

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Valued Contributor

## 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

Contributor III

## Re: convert number to minute and seconde

Hello,

The solution is :