2 Replies Latest reply: Nov 16, 2010 2:25 PM by Steve Free RSS

    Display minutes as hh:mm

    Steve Free

      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