topic Networking days in QlikView https://community.qlik.com/t5/QlikView/Networking-days/m-p/875384#M470457 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I badly need some help. I need to find the total time a ticket was open.</P><P>Note that the working hours of the company is 08:00 to 18:00 and from Monday to Friday.</P><P>I need qlikview to consider a working day as 10 hours instead of 24 hours.</P><P></P><P>Example:</P><P></P><P>Ticket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Opening Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Closing date</P><P>TicketA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/01/2015&nbsp; 15:01:31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/02/2015&nbsp; 17:03:35</P><P></P><P></P><P>Do you guys have a magical formula to help me.</P><P>I tried everything on excel and qlikview but I can't find a way out.</P><P></P><P>I need to submit that report today. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P></P><P>Many Thanks,</P><P></P><P>Kind Regards</P></BODY></HTML> Mon, 18 May 2015 05:08:05 GMT 2015-05-18T05:08:05Z Networking days https://community.qlik.com/t5/QlikView/Networking-days/m-p/875384#M470457 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I badly need some help. I need to find the total time a ticket was open.</P><P>Note that the working hours of the company is 08:00 to 18:00 and from Monday to Friday.</P><P>I need qlikview to consider a working day as 10 hours instead of 24 hours.</P><P></P><P>Example:</P><P></P><P>Ticket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Opening Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Closing date</P><P>TicketA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/01/2015&nbsp; 15:01:31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/02/2015&nbsp; 17:03:35</P><P></P><P></P><P>Do you guys have a magical formula to help me.</P><P>I tried everything on excel and qlikview but I can't find a way out.</P><P></P><P>I need to submit that report today. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P></P><P>Many Thanks,</P><P></P><P>Kind Regards</P></BODY></HTML> Mon, 18 May 2015 05:08:05 GMT https://community.qlik.com/t5/QlikView/Networking-days/m-p/875384#M470457 2015-05-18T05:08:05Z Re: Networking days https://community.qlik.com/t5/QlikView/Networking-days/m-p/875385#M470458 <HTML><HEAD></HEAD><BODY><P>Go through this thread: <A href="https://community.qlik.com/message/252929">Re: Calculate hours between two Date/Time strings</A> Should be helpful for you.</P></BODY></HTML> Mon, 18 May 2015 05:35:14 GMT https://community.qlik.com/t5/QlikView/Networking-days/m-p/875385#M470458 tresB 2015-05-18T05:35:14Z