topic Seconds between two Times in QlikView https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261211#M1184274 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>You're right</P></BODY></HTML> Wed, 19 Oct 2011 20:59:52 GMT julruiz123 2011-10-19T20:59:52Z Seconds between two Times https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261209#M1184272 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In a table i have two times, what i need is to know how many seconds have elapsed between the two times.</P><P></P><P>With this sintax i get the hour and minuts but i need the seconds.</P><P></P><P></P><P><CODE>interval([Hora Fin] - [Hora Inico]) as Time</CODE></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 19 Oct 2011 20:35:18 GMT https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261209#M1184272 julruiz123 2011-10-19T20:35:18Z Re: Seconds between two Times https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261210#M1184273 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You are almost there! Use the following format to show the result in seconds:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>Interval([Hora Fin] - [Hora Inicio], 's') as Time</P></PRE><P></P><P>The 's' will make the Interval() be displayed in seconds.</P><P></P><P>Hope that helps.</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/people/mabaeyens" style="font-size: 12px; outline-style: none; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #007fc0; zoom: 1; background-position: no-repeat no-repeat;">Miguel Angel Baeyens</A></P><P>BI Consultant</P><P><A class="jive-link-external-small" href="http://www.grupocomex.com/" style="font-size: 12px; outline-style: none; color: #007fc0;">Comex Grupo Ibérica</A></P></BODY></HTML> Wed, 19 Oct 2011 20:45:28 GMT https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261210#M1184273 Miguel_Angel_Baeyens 2011-10-19T20:45:28Z Seconds between two Times https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261211#M1184274 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>You're right</P></BODY></HTML> Wed, 19 Oct 2011 20:59:52 GMT https://community.qlik.com/t5/QlikView/Seconds-between-two-Times/m-p/261211#M1184274 julruiz123 2011-10-19T20:59:52Z