topic Convert hour (numeric) value ( 1.25 ) to HH : MM format (1:25) in QlikView https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560155#M441239 <P>Hi, any Idea to convert from Hour in numeric Value (1.25) to HH:MM&nbsp; format (1:25) ?</P> Fri, 22 Mar 2019 14:47:42 GMT mack2018 2019-03-22T14:47:42Z Convert hour (numeric) value ( 1.25 ) to HH : MM format (1:25) https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560155#M441239 <P>Hi, any Idea to convert from Hour in numeric Value (1.25) to HH:MM&nbsp; format (1:25) ?</P> Fri, 22 Mar 2019 14:47:42 GMT https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560155#M441239 mack2018 2019-03-22T14:47:42Z Re: Convert hour (numeric) value ( 1.25 ) to HH : MM format (1:25) https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560159#M441240 <P>Try it with: time(time#(Field, 'h.mm'))</P><P>- Marcus</P> Fri, 22 Mar 2019 14:57:24 GMT https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560159#M441240 marcus_sommer 2019-03-22T14:57:24Z Re: Convert hour (numeric) value ( 1.25 ) to HH : MM format (1:25) https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560163#M441241 <P>Hi, try with</P><PRE>=Interval(1.25,'HH:MM')</PRE> Fri, 22 Mar 2019 15:03:04 GMT https://community.qlik.com/t5/QlikView/Convert-hour-numeric-value-1-25-to-HH-MM-format-1-25/m-p/1560163#M441241 sergio0592 2019-03-22T15:03:04Z