topic Convert seconds to minutes in QlikView https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739223#M1080035 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I have a field 'Call Duration' where the values are in seconds eg. 120.5, 130.2, 150. So, is there a way from where we could convert this into minutes. For gg. 120 will be considered 02:00 minutes and 150 will be considered as 02:30.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Jul 2014 14:13:50 GMT 2014-07-09T14:13:50Z Convert seconds to minutes https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739223#M1080035 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I have a field 'Call Duration' where the values are in seconds eg. 120.5, 130.2, 150. So, is there a way from where we could convert this into minutes. For gg. 120 will be considered 02:00 minutes and 150 will be considered as 02:30.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Jul 2014 14:13:50 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739223#M1080035 2014-07-09T14:13:50Z Re: Convert seconds to minutes https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739224#M1080036 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try below</P><P></P><P>=interval(timestamp#(120, 's'), 'm')</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 09 Jul 2014 14:20:03 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739224#M1080036 ashfaq_haseeb 2014-07-09T14:20:03Z Re: Convert seconds to minutes https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739225#M1080037 <HTML><HEAD></HEAD><BODY><P>Thanks Ashfaq, but it didn't work.<BR /><BR /></P></BODY></HTML> Wed, 09 Jul 2014 14:26:24 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739225#M1080037 2014-07-09T14:26:24Z Re: Convert seconds to minutes https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739226#M1080038 <HTML><HEAD></HEAD><BODY><P>I got it.</P><P></P><P>You will have to divide the field with total no. of seconds in the day i.e. 86400 and in the properties of chart in number tab you will have to choose Time and&nbsp; remove h and TT which will look like mm:ss after modified.</P><P></P><P>Thanks everyone.</P></BODY></HTML> Wed, 09 Jul 2014 14:54:35 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739226#M1080038 2014-07-09T14:54:35Z Re: Re: Convert seconds to minutes https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739227#M1080039 <HTML><HEAD></HEAD><BODY><P>I got the same answer than you using a excel sheet for calculations.</P><P></P><P>Nice!!!</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 09 Jul 2014 15:32:09 GMT https://community.qlik.com/t5/QlikView/Convert-seconds-to-minutes/m-p/739227#M1080039 agomes1971 2014-07-09T15:32:09Z