topic Re: Calculate Elapsed Time Nett in QlikView https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905882#M314817 <HTML><HEAD></HEAD><BODY><P>See this discussion: <A href="https://community.qlik.com/thread/60227">Calculate hours between two Date/Time strings</A></P></BODY></HTML> Sun, 24 May 2015 19:03:13 GMT Gysbert_Wassenaar 2015-05-24T19:03:13Z Calculate Elapsed Time Nett https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905880#M314815 <HTML><HEAD></HEAD><BODY><P>hi all, I need your expertise help. </P><P></P><P></P><P>On a table with to fields, "Open Time" and "Close Time" (Those fields establish the time in and time out of tickets) is necessary to calculate the elapsed time nett in hours. For that i have to remove weekends and also the service time : Monday-Friday (08:00 - 22:00)</P><P></P><P></P><P>any help please?</P><P></P><P>Thanks in Advanced!!!</P><P></P><P>PD: attached an excell file with examples</P></BODY></HTML> Thu, 21 May 2015 14:19:02 GMT https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905880#M314815 2015-05-21T14:19:02Z Re: Calculate Elapsed Time Nett https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905881#M314816 <HTML><HEAD></HEAD><BODY><P>in the attachment my idea</P></BODY></HTML> Sat, 23 May 2015 12:01:25 GMT https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905881#M314816 maxgro 2015-05-23T12:01:25Z Re: Calculate Elapsed Time Nett https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905882#M314817 <HTML><HEAD></HEAD><BODY><P>See this discussion: <A href="https://community.qlik.com/thread/60227">Calculate hours between two Date/Time strings</A></P></BODY></HTML> Sun, 24 May 2015 19:03:13 GMT https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905882#M314817 Gysbert_Wassenaar 2015-05-24T19:03:13Z Re: Calculate Elapsed Time Nett https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905883#M314818 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert!!!</P></BODY></HTML> Mon, 25 May 2015 09:02:42 GMT https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905883#M314818 2015-05-25T09:02:42Z Re: Calculate Elapsed Time Nett https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905884#M314819 <HTML><HEAD></HEAD><BODY><P>Thanks Massimo, its perfect!!</P></BODY></HTML> Mon, 25 May 2015 11:09:40 GMT https://community.qlik.com/t5/QlikView/Calculate-Elapsed-Time-Nett/m-p/905884#M314819 2015-05-25T11:09:40Z