Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display minutes as hh:mm

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

2 Replies
pover
Luminary Alumni
Luminary Alumni

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
Not applicable
Author

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