topic Re: Calculating time to close the case in QlikView https://community.qlik.com/t5/QlikView/Calculating-time-to-close-the-case/m-p/747430#M266724 <HTML><HEAD></HEAD><BODY><P>To exclude the weekends you could use networkdays():</P><P></P><P>networkdays(floor([Case Created]), floor([Case Closed]))</P><P></P><P>and then adds the time:</P><P></P><P>frac([Case Closed]) - frac([Case Created])</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 01 Dec 2014 11:36:24 GMT marcus_sommer 2014-12-01T11:36:24Z Calculating time to close the case https://community.qlik.com/t5/QlikView/Calculating-time-to-close-the-case/m-p/747429#M266723 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P>I attached a file and want to calculate the no of days, hours and minutes took to close the case in different column in qlikview <STRONG style="color: #ff0000;">excluding the</STRONG> <STRONG style=": ; color: #ff0000;">weekends</STRONG> . And status as "Closed" or "Pending".</P><P></P><P>The field which is blank will be the today's time and status will be as "Pending".</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 432px;"><TBODY><TR><TD height="20" width="64">Ticket No</TD><TD width="64">User </TD><TD width="128">Case Created</TD><TD width="176">Case Closed</TD></TR><TR><TD align="right" height="20">1</TD><TD>abc1</TD><TD align="right" class="xl63">19/11/2014 11:45</TD><TD align="right" class="xl63">29/11/2014 12:50</TD></TR><TR><TD align="right" height="20">2</TD><TD>abc2</TD><TD align="right" class="xl63">19/11/2014 16:30</TD><TD align="right" class="xl63">19/11/2014 17:18</TD></TR><TR><TD align="right" height="20">3</TD><TD>abc3</TD><TD align="right" class="xl63">24/11/2014 11:45</TD><TD align="right" class="xl63">27/11/2014 12:25</TD></TR><TR><TD align="right" height="20">4</TD><TD>abc4</TD><TD align="right" class="xl63">19/11/2014 08:30</TD><TD align="right" class="xl63">19/11/2014 11:50</TD></TR><TR><TD align="right" height="20">5</TD><TD>abc5</TD><TD align="right" class="xl63">22/11/2014 14:30</TD><TD align="right" class="xl63">24/11/2014 15:30</TD></TR><TR><TD align="right" height="20">6</TD><TD>abc6</TD><TD align="right" class="xl63">19/11/2014 19:15</TD></TR><TR><TD align="right" height="20">7</TD><TD>abc7</TD><TD align="right" class="xl63">20/11/2014 16:05</TD><TD align="right" class="xl63">20/11/2014 17:00</TD></TR><TR><TD align="right" height="20">8</TD><TD>abc8</TD><TD align="right" class="xl63">20/11/2014 16:05</TD><TD align="right" class="xl63">21/11/2014 12:00</TD></TR><TR><TD align="right" height="20">9</TD><TD>abc9</TD><TD align="right" class="xl63">27/11/2014 12:30</TD><TD align="right" class="xl63">28/11/2014 11:30</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 01 Dec 2014 09:30:42 GMT https://community.qlik.com/t5/QlikView/Calculating-time-to-close-the-case/m-p/747429#M266723 2014-12-01T09:30:42Z Re: Calculating time to close the case https://community.qlik.com/t5/QlikView/Calculating-time-to-close-the-case/m-p/747430#M266724 <HTML><HEAD></HEAD><BODY><P>To exclude the weekends you could use networkdays():</P><P></P><P>networkdays(floor([Case Created]), floor([Case Closed]))</P><P></P><P>and then adds the time:</P><P></P><P>frac([Case Closed]) - frac([Case Created])</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 01 Dec 2014 11:36:24 GMT https://community.qlik.com/t5/QlikView/Calculating-time-to-close-the-case/m-p/747430#M266724 marcus_sommer 2014-12-01T11:36:24Z