topic Re: conversion of hrs into mins at script side in QlikView https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639688#M234532 <HTML><HEAD></HEAD><BODY><P>Load SubField(Val,':',1) &amp; ':' &amp; Ceil(SubField(Val,':',2)*60/100) Inline [</P><P>Val</P><P>60:90 ];</P></BODY></HTML> Tue, 20 May 2014 10:59:23 GMT anbu1984 2014-05-20T10:59:23Z conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639685#M234529 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I want to convert hours into minutes in script side.</P><P></P><P>EX : I have value 60:90 in that i want to convert 93 as</P><P></P><P>93 = 93*60 = 55 mins so at the end i want value as&nbsp; 60.55 in script <A href="https://community.qlik.com/qlik-users/2001">QlikTech Admin</A></P></BODY></HTML> Tue, 20 May 2014 10:21:24 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639685#M234529 2014-05-20T10:21:24Z Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639686#M234530 <HTML><HEAD></HEAD><BODY><P>How did you get 93? What is 93? Hrs?</P></BODY></HTML> Tue, 20 May 2014 10:49:18 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639686#M234530 anbu1984 2014-05-20T10:49:18Z Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639687#M234531 <HTML><HEAD></HEAD><BODY><P>Hi anbu cheliyan,</P><P></P><P>Sorry 90 will convert into mins as 90 * 60 = 54&nbsp; means finally i will get 60:64</P></BODY></HTML> Tue, 20 May 2014 10:51:03 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639687#M234531 2014-05-20T10:51:03Z Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639688#M234532 <HTML><HEAD></HEAD><BODY><P>Load SubField(Val,':',1) &amp; ':' &amp; Ceil(SubField(Val,':',2)*60/100) Inline [</P><P>Val</P><P>60:90 ];</P></BODY></HTML> Tue, 20 May 2014 10:59:23 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639688#M234532 anbu1984 2014-05-20T10:59:23Z Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639689#M234533 <HTML><HEAD></HEAD><BODY><P>Hi Varde,</P><P></P><P>It seems you missed something, Send some sample file.</P><P></P><P>Regards,</P><P>Chinni Kanna</P></BODY></HTML> Tue, 20 May 2014 11:08:00 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639689#M234533 2014-05-20T11:08:00Z Re: Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639690#M234534 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Please find an attachment</P></BODY></HTML> Tue, 20 May 2014 12:23:33 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639690#M234534 2014-05-20T12:23:33Z Re: conversion of hrs into mins at script side https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639691#M234535 <HTML><HEAD></HEAD><BODY><P>Are you converting StandardProcessingTime to HH:MM?</P></BODY></HTML> Tue, 20 May 2014 13:16:44 GMT https://community.qlik.com/t5/QlikView/conversion-of-hrs-into-mins-at-script-side/m-p/639691#M234535 anbu1984 2014-05-20T13:16:44Z