topic Timestamp Difference in QlikView https://community.qlik.com/t5/QlikView/Timestamp-Difference/m-p/689911#M1077964 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to calcualate difference between two timestamps based on working days Monday to Friday and working time 9am to 5pm only. example as below</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="74" style="width: 445px; height: 26px; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Entered Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Analysed Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">04/07/2014 14:30:00</TD><TD style="padding: 2px;">07/07/2014 12:00:00</TD><TD style="padding: 2px;">3.5</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 16 Jul 2014 15:06:59 GMT 2014-07-16T15:06:59Z Timestamp Difference https://community.qlik.com/t5/QlikView/Timestamp-Difference/m-p/689911#M1077964 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to calcualate difference between two timestamps based on working days Monday to Friday and working time 9am to 5pm only. example as below</P><P></P><P></P><TABLE border="1" class="jiveBorder" height="74" style="width: 445px; height: 26px; border: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Entered Data</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Analysed Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">04/07/2014 14:30:00</TD><TD style="padding: 2px;">07/07/2014 12:00:00</TD><TD style="padding: 2px;">3.5</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 16 Jul 2014 15:06:59 GMT https://community.qlik.com/t5/QlikView/Timestamp-Difference/m-p/689911#M1077964 2014-07-16T15:06:59Z