This content has been marked as final. Show 2 replies
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