Display minutes as hh:mm

[Anonymous]

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

[pover]

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.

[Anonymous]

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