Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
=floor(145.5) & ' days ' & hour(145.5) & ' hours ' & Minute(145.5) & ' minutes'
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))
Thanks for your reply but what is $1 in your formula?
Thats denoting the first parameter in