Converting number of minutes to output of "X Days, X Hours, X seconds"

[Sazabi]

Hi Qliksters,

Is there a nice and easy way to convert number of minutes to something formatted like "X Days, X Hours, X Seconds"?

For example, I have 1897.64 minutes.

I want that number converted to an output of "1 Day, 7 Hours, 37.64 Minutes" in a table.

Possible? Or do I have to go crazy with string manipulation? 

Thanks!

S

[Taoufiq_Zarra]

you can

=interval( Field / 1440, 'dd:hh:mm.ss')

for this format :

or add subfield like :

=subfield(interval( Field / 1440, 'dd:hh:mm.ss'),':',1)&' Day,'&subfield(interval( Field / 1440, 'dd:hh:mm.ss'),':',2)&' Hours,'&subfield(interval( Field / 1440, 'dd:hh:mm.ss'),':',3)&' Minutes'