Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'