Format interval function

[sergio0592]

Hi all,

I'd like to format inteval in order to get the output below (with XX d, XX h, XX m instead XX:XX:XX)

Is it possible?

Regards

[swuehl]

=floor(145.5) & ' days ' & hour(145.5) & ' hours ' & Minute(145.5) & ' minutes'

[swuehl · Accepted solution]

You can also create a variable in your script:

SET vInterval2 = Dual(floor($1) & ' days ' & hour($1) & ' hours ' & Minute($1) & ' minutes',$1);

and then use

=$(vInterval2(145.5))

[sergio0592]

Thanks for your reply but what is $1 in your formula?

[swuehl]

Thats denoting the first parameter in

Dollar-sign expansion using parameters ‒ QlikView