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

    Calculations + conversion

    Joanna Seldon


      Hiya

       

      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

       

      Joeybird