topic Timestamp in hours in QlikView https://community.qlik.com/t5/QlikView/Timestamp-in-hours/m-p/582148#M1115462 <HTML><HEAD></HEAD><BODY><P>I have the following data in notepad file. </P><P><BR />Process_Code Application_id Workitem_Id Activity_Code Txn_Date State_Code Assigned_User_Id Assigned_Dept_Id Actioned_User_Id<BR />NAP 10003507 79909714 NBG 2013-09-06 10:32:39.900 CMP NULL NULL 99999<BR />NAP 10003507 79909714 NBG 2013-09-06 10:32:39.900 RDY NULL NULL 99999<BR />NAP 10003507 79909715 NSA 2013-09-06 10:32:39.900 RDY NULL NULL 99999<BR />NAP 10003507 79909715 NSA 2013-09-11 09:00:28.380 RUN NULL NULL 12781<BR />NAP 10003507 79909715 NSA 2013-09-11 09:21:09.713 CMP NULL NULL 12781<BR />NAP 10003507 80307667 NSX 2013-09-11 09:21:09.713 RDY NULL NULL 12781<BR />NAP 10003507 80307667 NSX 2013-09-11 09:44:07.147 RUN NULL NULL 29037<BR />NAP 10003507 80307667 NSX 2013-09-11 09:44:10.617 CMP NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:10.617 RDY NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:11.787 RUN NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:29.117 CMP NULL NULL 29037<BR />NAP 10003507 80308424 NSX 2013-09-11 09:44:29.117 RDY NULL NULL 29037<BR />NAP 10003507 80308424 NSX 2013-09-11 09:44:34.600 TRM NULL NULL 29037<BR />NAP 10003507 80403761 NBG 2013-09-17 17:01:54.310 RDY NULL NULL 99999<BR />NAP 10003507 80403761 NBG 2013-09-17 17:01:54.327 CMP NULL NULL 99999<BR />NAP 10003507 80403762 NSA 2013-09-17 17:01:54.327 RDY NULL NULL 99999<BR />NAP 10003507 80403762 NSA 2013-09-19 15:48:37.117 RUN NULL NULL 29037<BR />NAP 10003507 80403762 NSA 2013-09-19 15:57:16.813 CMP NULL NULL 29037<BR />NAP 10003507 80438748 CJA 2013-09-19 15:57:16.813 RDY NULL NULL 29037<BR />NAP 10003507 80438748 CJA 2013-09-19 16:02:13.400 CMP NULL NULL 99999<BR />NAP 10003507 80438829 NCO 2013-09-19 16:02:13.413 RDY NULL NULL 99999<BR />NAP 10003507 80438829 NCO 2013-09-19 16:20:41.390 RUN NULL NULL 29396<BR />NAP 10003507 80438829 NCO 2013-09-19 16:21:07.717 CMP NULL NULL 29396<BR />NAP 10003507 80439054 NFU 2013-09-19 16:21:07.717 SUS NULL NULL 29396<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:40.923 RDY NULL NULL 88603<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:41.033 RUN NULL NULL 88603<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:50.877 CMP NULL NULL 88603<BR />NAP 10003507 80507822 NCH 2013-09-25 08:21:50.893 RDY NULL NULL 88603<BR />NAP 10003507 80507822 NCH 2013-09-25 15:24:55.157 RUN NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:24:58.657 RDY NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:25:05.563 RUN NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:28:54.660 CMP NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:28:54.660 RDY NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:28:58.067 RUN NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:29:02.910 CMP NULL NULL 15095<BR />NAP 10003507 80515614 NCA 2013-09-25 15:29:02.910 CMP NULL NULL 99999<BR />NAP 10003507 80515614 NCA 2013-09-25 15:29:02.910 RDY NULL NULL</P><P></P><P>Each application passes through different trays but I am only intersted in the following Activity_Code. </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 412px;"><TBODY><TR><TD class="xl24" height="17" width="186"><STRONG>Tray</STRONG></TD><TD class="xl24" width="115"><STRONG>Activity_Code</STRONG></TD><TD class="xl25" width="111"><STRONG>Application Status</STRONG></TD></TR><TR><TD height="17">NAPS Contact Customer</TD><TD>NCO</TD><TD>Outbound</TD></TR><TR><TD height="17">NAPS Print Documents</TD><TD>NDO</TD><TD>Outbound</TD></TR><TR><TD height="17">NAPS Follow Up Docs</TD><TD>NFU</TD><TD>Customer</TD></TR><TR><TD height="17">NAPS Returned Documents</TD><TD>NRD</TD><TD>Customer</TD></TR><TR><TD height="17">NAPS Check Documents</TD><TD>NCH</TD><TD>Inbound</TD></TR><TR><TD height="17">NAPS Security Perfection</TD><TD>NSP</TD><TD>Security</TD></TR><TR><TD height="17">NAPS Sec Special Conditions</TD><TD>NSC</TD><TD>Booked</TD></TR><TR><TD height="17">NAPS Booking</TD><TD>NBO</TD><TD>Booked</TD></TR><TR><TD height="17">NAPS Call Off</TD><TD>NCA</TD><TD>Booked</TD></TR></TBODY></TABLE><P></P><P>Each tray has different State_Code a below.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 301px;"><TBODY><TR><TD class="xl24" height="17" width="186"><STRONG>State_Code</STRONG></TD><TD class="xl24" width="115"><STRONG>Code description</STRONG></TD></TR><TR><TD height="17">RDY</TD><TD>Ready to work</TD></TR><TR><TD height="17">RUN</TD><TD>In process</TD></TR><TR><TD height="17">TRM</TD><TD>Terminated</TD></TR><TR><TD height="17">CMP</TD><TD>Completed</TD></TR></TBODY></TABLE><P></P><P>I want to calculate time in hours only workingdays in each application_status when State_code is 'CMP' when application changes its application_status from one to other e.g. from outbound to customer. start time = 9:00:00 and quit time = 17:00:00.</P></BODY></HTML> Thu, 13 Feb 2014 15:33:22 GMT 2014-02-13T15:33:22Z Timestamp in hours https://community.qlik.com/t5/QlikView/Timestamp-in-hours/m-p/582148#M1115462 <HTML><HEAD></HEAD><BODY><P>I have the following data in notepad file. </P><P><BR />Process_Code Application_id Workitem_Id Activity_Code Txn_Date State_Code Assigned_User_Id Assigned_Dept_Id Actioned_User_Id<BR />NAP 10003507 79909714 NBG 2013-09-06 10:32:39.900 CMP NULL NULL 99999<BR />NAP 10003507 79909714 NBG 2013-09-06 10:32:39.900 RDY NULL NULL 99999<BR />NAP 10003507 79909715 NSA 2013-09-06 10:32:39.900 RDY NULL NULL 99999<BR />NAP 10003507 79909715 NSA 2013-09-11 09:00:28.380 RUN NULL NULL 12781<BR />NAP 10003507 79909715 NSA 2013-09-11 09:21:09.713 CMP NULL NULL 12781<BR />NAP 10003507 80307667 NSX 2013-09-11 09:21:09.713 RDY NULL NULL 12781<BR />NAP 10003507 80307667 NSX 2013-09-11 09:44:07.147 RUN NULL NULL 29037<BR />NAP 10003507 80307667 NSX 2013-09-11 09:44:10.617 CMP NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:10.617 RDY NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:11.787 RUN NULL NULL 29037<BR />NAP 10003507 80308416 NSA 2013-09-11 09:44:29.117 CMP NULL NULL 29037<BR />NAP 10003507 80308424 NSX 2013-09-11 09:44:29.117 RDY NULL NULL 29037<BR />NAP 10003507 80308424 NSX 2013-09-11 09:44:34.600 TRM NULL NULL 29037<BR />NAP 10003507 80403761 NBG 2013-09-17 17:01:54.310 RDY NULL NULL 99999<BR />NAP 10003507 80403761 NBG 2013-09-17 17:01:54.327 CMP NULL NULL 99999<BR />NAP 10003507 80403762 NSA 2013-09-17 17:01:54.327 RDY NULL NULL 99999<BR />NAP 10003507 80403762 NSA 2013-09-19 15:48:37.117 RUN NULL NULL 29037<BR />NAP 10003507 80403762 NSA 2013-09-19 15:57:16.813 CMP NULL NULL 29037<BR />NAP 10003507 80438748 CJA 2013-09-19 15:57:16.813 RDY NULL NULL 29037<BR />NAP 10003507 80438748 CJA 2013-09-19 16:02:13.400 CMP NULL NULL 99999<BR />NAP 10003507 80438829 NCO 2013-09-19 16:02:13.413 RDY NULL NULL 99999<BR />NAP 10003507 80438829 NCO 2013-09-19 16:20:41.390 RUN NULL NULL 29396<BR />NAP 10003507 80438829 NCO 2013-09-19 16:21:07.717 CMP NULL NULL 29396<BR />NAP 10003507 80439054 NFU 2013-09-19 16:21:07.717 SUS NULL NULL 29396<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:40.923 RDY NULL NULL 88603<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:41.033 RUN NULL NULL 88603<BR />NAP 10003507 80439054 NFU 2013-09-25 08:21:50.877 CMP NULL NULL 88603<BR />NAP 10003507 80507822 NCH 2013-09-25 08:21:50.893 RDY NULL NULL 88603<BR />NAP 10003507 80507822 NCH 2013-09-25 15:24:55.157 RUN NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:24:58.657 RDY NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:25:05.563 RUN NULL NULL 15095<BR />NAP 10003507 80507822 NCH 2013-09-25 15:28:54.660 CMP NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:28:54.660 RDY NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:28:58.067 RUN NULL NULL 15095<BR />NAP 10003507 80515611 NBO 2013-09-25 15:29:02.910 CMP NULL NULL 15095<BR />NAP 10003507 80515614 NCA 2013-09-25 15:29:02.910 CMP NULL NULL 99999<BR />NAP 10003507 80515614 NCA 2013-09-25 15:29:02.910 RDY NULL NULL</P><P></P><P>Each application passes through different trays but I am only intersted in the following Activity_Code. </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 412px;"><TBODY><TR><TD class="xl24" height="17" width="186"><STRONG>Tray</STRONG></TD><TD class="xl24" width="115"><STRONG>Activity_Code</STRONG></TD><TD class="xl25" width="111"><STRONG>Application Status</STRONG></TD></TR><TR><TD height="17">NAPS Contact Customer</TD><TD>NCO</TD><TD>Outbound</TD></TR><TR><TD height="17">NAPS Print Documents</TD><TD>NDO</TD><TD>Outbound</TD></TR><TR><TD height="17">NAPS Follow Up Docs</TD><TD>NFU</TD><TD>Customer</TD></TR><TR><TD height="17">NAPS Returned Documents</TD><TD>NRD</TD><TD>Customer</TD></TR><TR><TD height="17">NAPS Check Documents</TD><TD>NCH</TD><TD>Inbound</TD></TR><TR><TD height="17">NAPS Security Perfection</TD><TD>NSP</TD><TD>Security</TD></TR><TR><TD height="17">NAPS Sec Special Conditions</TD><TD>NSC</TD><TD>Booked</TD></TR><TR><TD height="17">NAPS Booking</TD><TD>NBO</TD><TD>Booked</TD></TR><TR><TD height="17">NAPS Call Off</TD><TD>NCA</TD><TD>Booked</TD></TR></TBODY></TABLE><P></P><P>Each tray has different State_Code a below.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 301px;"><TBODY><TR><TD class="xl24" height="17" width="186"><STRONG>State_Code</STRONG></TD><TD class="xl24" width="115"><STRONG>Code description</STRONG></TD></TR><TR><TD height="17">RDY</TD><TD>Ready to work</TD></TR><TR><TD height="17">RUN</TD><TD>In process</TD></TR><TR><TD height="17">TRM</TD><TD>Terminated</TD></TR><TR><TD height="17">CMP</TD><TD>Completed</TD></TR></TBODY></TABLE><P></P><P>I want to calculate time in hours only workingdays in each application_status when State_code is 'CMP' when application changes its application_status from one to other e.g. from outbound to customer. start time = 9:00:00 and quit time = 17:00:00.</P></BODY></HTML> Thu, 13 Feb 2014 15:33:22 GMT https://community.qlik.com/t5/QlikView/Timestamp-in-hours/m-p/582148#M1115462 2014-02-13T15:33:22Z