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

    Calls Duration in minutes

    Andrea Rebora

      Hello,

       

      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:

      LOAD

       

         Duration,

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

       

      FROM

       

      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.

       

      Andrea