4 Replies Latest reply: Apr 9, 2015 10:10 AM by Joanna Seldon RSS

    Calculations + conversion

    Joanna Seldon



      I have column called duration, its just a single numbers e.g 210


      I have successfully converted this to minutes using


      div([Duration], 60) & ':' & Mod([ Duration], 60)


      and formatted the KPI to duration to show 3:30


      all good if you want to do this for a single line of data


      problem... I want to add up a number of columns


      I have used this


      sum([Duration]) + Div([Duration], 60) & ':' & Mod([Duration], 60)


      to try and add up all the columns and the convert to minutes


      it maybe a typo. I have tried different variant's and no joy


      please help


      Kind Regards