topic Re: Convert Time to Integer in QlikView https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37812#M1248762 <HTML><HEAD></HEAD><BODY><P>thats it. thank you.</P></BODY></HTML> Thu, 31 May 2018 12:34:13 GMT rustyfishbones 2018-05-31T12:34:13Z Convert Time to Integer https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37808#M1248750 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the following</P><P></P><P>=TIME('$(now)' - TIME(MIN({&lt;[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}&gt;}StartTime),'hh:mm'),'hh:mm')</P><P></P><P>which returns 04:10</P><P></P><P>I need to covert this to a number, can you help.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37808#M1248750 rustyfishbones 2026-01-26T18:19:17Z Re: Convert Time to Integer https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37809#M1248753 <HTML><HEAD></HEAD><BODY><P>Hi Alan,</P><P></P><P>it's returning the result in hours and Minutes ...</P><P></P><P>you want to convert it into Number ?</P><P></P><P>can you let me know what will be the result of <STRONG>04:10</STRONG> when you convert into Number ? // As a Sample</P></BODY></HTML> Thu, 31 May 2018 12:19:17 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37809#M1248753 mdmukramali 2018-05-31T12:19:17Z Re: Convert Time to Integer https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37810#M1248755 <HTML><HEAD></HEAD><BODY><P>4.16?</P></BODY></HTML> Thu, 31 May 2018 12:21:17 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37810#M1248755 rustyfishbones 2018-05-31T12:21:17Z Re: Convert Time to Integer https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37811#M1248758 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Hour(('$(now)' - MIN({&lt;[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}&gt;}StartTime))) + (Minute(('$(now)' - MIN({&lt;[TrxType] = {'D'},ActionID = {'PICKCASE'}, FromChamber = {'PR'}&gt;}StartTime)))/60)</STRONG></P></BODY></HTML> Thu, 31 May 2018 12:30:21 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37811#M1248758 sunny_talwar 2018-05-31T12:30:21Z Re: Convert Time to Integer https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37812#M1248762 <HTML><HEAD></HEAD><BODY><P>thats it. thank you.</P></BODY></HTML> Thu, 31 May 2018 12:34:13 GMT https://community.qlik.com/t5/QlikView/Convert-Time-to-Integer/m-p/37812#M1248762 rustyfishbones 2018-05-31T12:34:13Z