topic Calculate Total Hours in QlikView https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70453#M786367 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P><STRONG>I have start date and end date and want to calculate Total Hours </STRONG><SPAN style="font-size: 11.0pt; font-family: 'Calibri Light','sans-serif'; color: black;"><STRONG> (8 a.m. - 5 p.m., Monday -Friday), excluding weekends.</STRONG></SPAN></P><P></P><P>Start 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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Date </P><P>4/27/2009&nbsp; 3:34:56 PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/28/2009 6:30:00 PM</P><P></P><P></P><P>How to achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Calculate Total Hours https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70453#M786367 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P><STRONG>I have start date and end date and want to calculate Total Hours </STRONG><SPAN style="font-size: 11.0pt; font-family: 'Calibri Light','sans-serif'; color: black;"><STRONG> (8 a.m. - 5 p.m., Monday -Friday), excluding weekends.</STRONG></SPAN></P><P></P><P>Start 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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End Date </P><P>4/27/2009&nbsp; 3:34:56 PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/28/2009 6:30:00 PM</P><P></P><P></P><P>How to achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70453#M786367 Anonymous 2020-11-25T16:16:04Z Re: Calculate Total Hours https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70454#M786368 <HTML><HEAD></HEAD><BODY><P>Have a look at</P><P><A href="https://community.qlik.com/thread/60227">Calculate hours between two Date/Time strings</A></P></BODY></HTML> Thu, 22 Feb 2018 10:39:16 GMT https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70454#M786368 swuehl 2018-02-22T10:39:16Z Re: Calculate Total Hours https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70455#M786369 <HTML><HEAD></HEAD><BODY><P>Hi <A href="https://community.qlik.com/qlik-users/15823">swuehl</A>‌,</P><P></P><P>Actually I am looking for this ...</P><P></P><P>PFA</P></BODY></HTML> Thu, 22 Feb 2018 11:13:31 GMT https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70455#M786369 Anonymous 2018-02-22T11:13:31Z Re: Calculate Total Hours https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70456#M786370 <HTML><HEAD></HEAD><BODY><P>Ok, but where is the problem applying the code I have linked to?</P></BODY></HTML> Thu, 22 Feb 2018 11:21:52 GMT https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70456#M786370 swuehl 2018-02-22T11:21:52Z Re: Calculate Total Hours https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70457#M786371 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/15823">swuehl</A>‌</P><P></P><P>if i use your logic for my data then will i get desire output ??</P><P></P><P>Thanks </P></BODY></HTML> Fri, 23 Feb 2018 04:57:34 GMT https://community.qlik.com/t5/QlikView/Calculate-Total-Hours/m-p/70457#M786371 Anonymous 2018-02-23T04:57:34Z