2 Replies Latest reply: Jan 29, 2018 1:28 PM by Juan Moreno RSS

    Time format m:ss

    Juan Moreno

      Hi,

       

      Do you know if I can use something like time(Time#(traveltime,'s'),'m:ss')) so the result of an expression is shown in minutes:seconds instead of as a decimal number?

       

      I thought I had use something like that successfully in other occasions, but now for some reason every time I try to do the conversion I get a zero as a result.

       

      My expression is currently looking like this:

       

      Sum({<[link.id]={'255500','255480','255460'}>}

      Aggr(Avg({<[link.id]={'255500','255480','255460'},link_YearMonth={"$(=Date(AddMonths(Today(),-1),'YYYY-MM'))"},link_WeekDay-={'Sat','Sun'},PeakPeriodId={'1'}>}traveltime/60),[link.id]))

       

      So the result is 7.3. I'd like to see something like 7:20.

       

      Thanks much.