topic Sumar intervalos de tiempo in QlikView https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343028#M126685 <HTML><HEAD></HEAD><BODY><P>Hola, </P><P></P><P>Estoy intentando sumar minutos en formato numérico a una hora de tipo Time.</P><P>En una columna tendría la [Hora Inicio] y en otra Minutos para sumarlas y obtener la columna [Hora Fin] de esta forma:</P><P></P><P>[Hora Inicio]&nbsp;&nbsp;&nbsp;&nbsp; Minutos&nbsp;&nbsp;&nbsp;&nbsp; [Hora Fin]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 00:30:00</P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:00:00</P><P>01:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:30:00</P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:30:00</P><P>...</P><P></P><P></P><P>Gracias de antemano por cualquier idea que me pueda ayudar.</P><P></P><P>Saludos</P></BODY></HTML> Thu, 08 Mar 2012 14:42:47 GMT chematos 2012-03-08T14:42:47Z Sumar intervalos de tiempo https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343028#M126685 <HTML><HEAD></HEAD><BODY><P>Hola, </P><P></P><P>Estoy intentando sumar minutos en formato numérico a una hora de tipo Time.</P><P>En una columna tendría la [Hora Inicio] y en otra Minutos para sumarlas y obtener la columna [Hora Fin] de esta forma:</P><P></P><P>[Hora Inicio]&nbsp;&nbsp;&nbsp;&nbsp; Minutos&nbsp;&nbsp;&nbsp;&nbsp; [Hora Fin]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 00:30:00</P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:00:00</P><P>01:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:30:00</P><P>00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01:30:00</P><P>...</P><P></P><P></P><P>Gracias de antemano por cualquier idea que me pueda ayudar.</P><P></P><P>Saludos</P></BODY></HTML> Thu, 08 Mar 2012 14:42:47 GMT https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343028#M126685 chematos 2012-03-08T14:42:47Z Sumar intervalos de tiempo https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343029#M126686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Check with this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [Hora Inicio],</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Minutos,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Interval(Time([Hora Inicio])+Time#(Floor(Minutos/60)&amp;':'&amp;Mod(Minutos,60),'h:m'),'hh:mm:ss') as [Hora Fin]</P><P>&nbsp;&nbsp;&nbsp;&nbsp; From...</P><P></P><P>Celambarasan</P></BODY></HTML> Thu, 08 Mar 2012 14:52:23 GMT https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343029#M126686 CELAMBARASAN 2012-03-08T14:52:23Z Sumar intervalos de tiempo https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343030#M126687 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Celambarasan</SPAN>,</P><P></P><P>it´s perfect, I only have had to change the first function Time to Time#: </P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;"> Interval(Time#([Hora Inicio])+Time#(Floor(Minutos/60)&amp;':'&amp;Mod(Minutos,60),'h:m'),'hh:mm:ss') as [Hora Fin]</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Thank you very much!</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Chema<BR /></SPAN></P></BODY></HTML> Thu, 08 Mar 2012 15:51:23 GMT https://community.qlik.com/t5/QlikView/Sumar-intervalos-de-tiempo/m-p/343030#M126687 chematos 2012-03-08T15:51:23Z