topic Converting an integer of minutes to hours, minutes and seconds in QlikView https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359849#M416907 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I tried to search the forums but couldn't find a response that was clear for this... I have a value of time in minutes that I'd like to format as hhh:mm:ss, I was thinking interval but this is giving me a really high number.</P><P><BR />For example, my value in minutes is 48.9666666667</P><P>I was thinking that interval needs to work in seconds so I divided this by 60 to give 0.81611111111</P><P>If I then do interval as: interval(time/60,'hhh:mm:ss) I get 019:35:12.</P><P></P><P>This is clearly wrong, as I know the value is 48 minutes and 59 seconds. Can someone help how I should proceed here, please?</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Tue, 13 Jun 2017 09:25:35 GMT Dayna 2017-06-13T09:25:35Z Converting an integer of minutes to hours, minutes and seconds https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359849#M416907 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I tried to search the forums but couldn't find a response that was clear for this... I have a value of time in minutes that I'd like to format as hhh:mm:ss, I was thinking interval but this is giving me a really high number.</P><P><BR />For example, my value in minutes is 48.9666666667</P><P>I was thinking that interval needs to work in seconds so I divided this by 60 to give 0.81611111111</P><P>If I then do interval as: interval(time/60,'hhh:mm:ss) I get 019:35:12.</P><P></P><P>This is clearly wrong, as I know the value is 48 minutes and 59 seconds. Can someone help how I should proceed here, please?</P><P></P><P>Kind Regards,</P><P>Dayna</P></BODY></HTML> Tue, 13 Jun 2017 09:25:35 GMT https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359849#M416907 Dayna 2017-06-13T09:25:35Z Re: Converting an integer of minutes to hours, minutes and seconds https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359850#M416908 <HTML><HEAD></HEAD><BODY><P>You can use =Interval(48.9666666667/60/24)</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Tue, 13 Jun 2017 09:36:13 GMT https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359850#M416908 daveamz 2017-06-13T09:36:13Z Re: Converting an integer of minutes to hours, minutes and seconds https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359851#M416909 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Tue, 13 Jun 2017 09:47:39 GMT https://community.qlik.com/t5/QlikView/Converting-an-integer-of-minutes-to-hours-minutes-and-seconds/m-p/1359851#M416909 Dayna 2017-06-13T09:47:39Z