Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - thanks in advance for your reply.
I have an expression as follows which displays total minutes as hh:mm:
=interval(timestamp#(sum([TR Minutes]*[TR Units]), 'm'),'h')
This displays as 12:06 (hh:mm) which is fine
However if the number of hours is over 24 it does not display correctly - for example 26:30 would display as 02:30, 49:30 would display as 01:30 - it's losing the days.
I need to show this ideally as 26:30 but failing that, show as dd:hh:mm
This might be an issue with the version you are using because the following expression gave me the result 33:20:00 in QlikView 10.
=interval(timestamp#(2000, 'm'), 'hh:mm:ss')
What do you get as a result?
Regards.
Karl
Your expression was slightly different to the one I used and by combining with expression default for number it's worked!
Thanks very much for your quick response