topic Re: Transformar Minutos em Horas in QlikView https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575004#M214102 <HTML><HEAD></HEAD><BODY><P>Hi! I know, I know! <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P></P><P>Time(Time#(100, 'mm'))</P><P></P><P>Regards,</P><P>Oleg</P></BODY></HTML> Wed, 12 Feb 2014 13:03:05 GMT oleg_orlov 2014-02-12T13:03:05Z Transformar Minutos em Horas https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575002#M214100 <HTML><HEAD></HEAD><BODY><P>Bom Dia a Todos.!</P><P>Este é meu primeiro Post. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P>Espero contribuir também sempre que for possível...!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Gostaria de saber se existe alguma função no QLIKVIEW que transforma a quantidade de Minutos em Horas.</P><P></P><P><STRONG>Ex:</STRONG></P><P>100 Minutos = 1,40 horas</P><P></P><P>Desde já, muito obrigado.</P><P></P><P>Renato</P></BODY></HTML> Wed, 12 Feb 2014 12:49:16 GMT https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575002#M214100 girino777 2014-02-12T12:49:16Z Re: Transformar Minutos em Horas https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575003#M214101 <HTML><HEAD></HEAD><BODY><P>Example 200 minutes:</P><P>floor(200/60) =3</P><P>LET myHour =&nbsp; Floor(200/60)+((200 - 60 * Floor(200/60))/100)</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 12 Feb 2014 12:55:22 GMT https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575003#M214101 alexandros17 2014-02-12T12:55:22Z Re: Transformar Minutos em Horas https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575004#M214102 <HTML><HEAD></HEAD><BODY><P>Hi! I know, I know! <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P></P><P>Time(Time#(100, 'mm'))</P><P></P><P>Regards,</P><P>Oleg</P></BODY></HTML> Wed, 12 Feb 2014 13:03:05 GMT https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575004#M214102 oleg_orlov 2014-02-12T13:03:05Z Re: Transformar Minutos em Horas https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575005#M214103 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>Olá Pessoal.!</SPAN></SPAN></P><P></P><P>Oleg, a sua resposta atende perfeitamente. <STRONG>OK.!</STRONG></P><P></P><P>Apenas para registro, a função abaixo também atende.</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Time (Time # (100, 'mm'))&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P>=interval(sum(100)/24/60,'hh:mm') <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Muito Obrigado.!</P><P></P><P>Renato</P></BODY></HTML> Wed, 12 Feb 2014 13:11:03 GMT https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575005#M214103 girino777 2014-02-12T13:11:03Z Re: Transformar Minutos em Horas https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575006#M214104 <HTML><HEAD></HEAD><BODY><P>Interval(Interval#(1000000, 'mm'), 'hh:mm') = 16666:40</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Time(Time#(1000000, 'mm'), 'hh:mm') = 10:40 (times can never be greater than 23:59:59)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">It's the difference.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Oleg<BR /></SPAN></P></BODY></HTML> Wed, 12 Feb 2014 13:25:07 GMT https://community.qlik.com/t5/QlikView/Transformar-Minutos-em-Horas/m-p/575006#M214104 oleg_orlov 2014-02-12T13:25:07Z