5 Replies Latest reply: Apr 10, 2012 12:24 PM by Miguel Angel Baeyens de Arce RSS

    Calls Duration in minutes

    Andrea Rebora



      I have a file in .csv with these fields: Caller ; Recipient ; Duration.

      The field "duration" is expressed in seconds (for ex:  06 , 10 ,11, 12, 13 , 24 , 31... 1000) what I need is this field in minutes.

      I tried to write this the script:




         num(Duration/60, ###.0) as DurataMinuti




      but if I insert a List Box, it makes ones like this picture. I need only one 0, 1, 2 etc  data.


      Do you have any suggestion?


      Thank you in advance.