topic Re: calculate working hours. in QlikView https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542045#M1128207 <HTML><HEAD></HEAD><BODY><P>I do prefer 24-hour time format <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>The script is a disaster but does it's job</P></BODY></HTML> Fri, 06 Dec 2013 21:39:36 GMT fred_s 2013-12-06T21:39:36Z calculate working hours. https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542043#M1128204 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>PFA,</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 398px;"><TBODY><TR><TD height="20" width="73">Emp_Id </TD><TD width="75">Date</TD><TD width="70">In-time</TD><TD width="81">Out-Time</TD><TD width="99">Working Hours</TD></TR><TR><TD height="20">c41059</TD><TD align="right" class="xl63">11/1/2013</TD><TD>9am</TD><TD>6pm</TD><TD></TD></TR><TR><TD height="20">c41060</TD><TD align="right" class="xl63">11/2/2013</TD><TD>9am</TD><TD>5pm</TD><TD></TD></TR><TR><TD height="20">c41061</TD><TD align="right" class="xl63">11/3/2013</TD><TD>9am</TD><TD>4:45pm</TD><TD></TD></TR><TR><TD height="20">c41062</TD><TD align="right" class="xl63">11/4/2013</TD><TD>9am</TD><TD>7pm</TD><TD></TD></TR><TR><TD height="20">c41063</TD><TD align="right" class="xl63">11/5/2013</TD><TD>9am</TD><TD>8pm</TD><TD></TD></TR><TR><TD height="20">c41064</TD><TD align="right" class="xl63">11/6/2013</TD><TD>9am</TD><TD>1pm</TD><TD></TD></TR><TR><TD height="20">c41065</TD><TD align="right" class="xl63">11/7/2013</TD><TD>9am</TD><TD>4pm</TD><TD></TD></TR><TR><TD height="20">c41066</TD><TD align="right" class="xl63">11/8/2013</TD><TD>9am</TD><TD>2:45pm</TD><TD></TD></TR><TR><TD height="20">c41067</TD><TD align="right" class="xl63">11/9/2013</TD><TD>9am</TD><TD>6pm</TD><TD></TD></TR><TR><TD height="20">c41068</TD><TD align="right" class="xl63">11/10/2013</TD><TD>9am</TD><TD>6pm</TD><TD></TD></TR><TR><TD height="20">c41069</TD><TD align="right" class="xl63">11/11/2013</TD><TD>9am</TD><TD>7pm</TD><TD></TD></TR><TR><TD height="20">c41070</TD><TD align="right" class="xl63">11/12/2013</TD><TD>9am</TD><TD>8pm</TD><TD></TD></TR><TR><TD height="20">c41071</TD><TD align="right" class="xl63">11/13/2013</TD><TD>9am</TD><TD>12:30pm</TD><TD></TD></TR></TBODY></TABLE><P>How to calculate <STRONG>working hours and sundays..</STRONG></P></BODY></HTML> Fri, 06 Dec 2013 19:57:07 GMT https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542043#M1128204 Nagaraju_KCS 2013-12-06T19:57:07Z Re: calculate working hours. https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542044#M1128205 <HTML><HEAD></HEAD><BODY><P>anyone can help me..</P></BODY></HTML> Fri, 06 Dec 2013 20:53:19 GMT https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542044#M1128205 Nagaraju_KCS 2013-12-06T20:53:19Z Re: calculate working hours. https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542045#M1128207 <HTML><HEAD></HEAD><BODY><P>I do prefer 24-hour time format <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>The script is a disaster but does it's job</P></BODY></HTML> Fri, 06 Dec 2013 21:39:36 GMT https://community.qlik.com/t5/QlikView/calculate-working-hours/m-p/542045#M1128207 fred_s 2013-12-06T21:39:36Z