topic Working with timestamps in QlikView https://community.qlik.com/t5/QlikView/Working-with-timestamps/m-p/1254831#M625047 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table, in which I store timeclock data (employee id, employee punch in time and date, employee punch out time and date).</P><P>See Sample attached.</P><P><IMG alt="33.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143932_33.PNG" style="height: auto;" /></P><P>All employees who work more than 5 hours in a single shift, qualify for a 30 minute paid lunch break.</P><P></P><P>In the example below, records 1 and 5 would qualify for a lunch break.</P><P>Record 1 is easy to adjust.</P><P>However, record 5 spans across two days (3 hours on 01/10/2016 and 3.5 hours on 1/11/2016). In these situations, I need to subtract 30 minutes from Hours Worked on a day with more hours worked (1/11/2016).</P><P>Following the adjustment, Hours worked would be: <SPAN style="font-size: 13.3333px;">3 hours on 01/10/2016 and 3 hours on 1/11/2016.</SPAN></P><P></P><P>How can I accomplish this in script?</P><P></P><P>Thank you very much in advance!</P><P></P><P>Marcin</P></BODY></HTML> Tue, 15 Nov 2016 16:47:13 GMT mszuberl 2016-11-15T16:47:13Z Working with timestamps https://community.qlik.com/t5/QlikView/Working-with-timestamps/m-p/1254831#M625047 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table, in which I store timeclock data (employee id, employee punch in time and date, employee punch out time and date).</P><P>See Sample attached.</P><P><IMG alt="33.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143932_33.PNG" style="height: auto;" /></P><P>All employees who work more than 5 hours in a single shift, qualify for a 30 minute paid lunch break.</P><P></P><P>In the example below, records 1 and 5 would qualify for a lunch break.</P><P>Record 1 is easy to adjust.</P><P>However, record 5 spans across two days (3 hours on 01/10/2016 and 3.5 hours on 1/11/2016). In these situations, I need to subtract 30 minutes from Hours Worked on a day with more hours worked (1/11/2016).</P><P>Following the adjustment, Hours worked would be: <SPAN style="font-size: 13.3333px;">3 hours on 01/10/2016 and 3 hours on 1/11/2016.</SPAN></P><P></P><P>How can I accomplish this in script?</P><P></P><P>Thank you very much in advance!</P><P></P><P>Marcin</P></BODY></HTML> Tue, 15 Nov 2016 16:47:13 GMT https://community.qlik.com/t5/QlikView/Working-with-timestamps/m-p/1254831#M625047 mszuberl 2016-11-15T16:47:13Z Re: Working with timestamps https://community.qlik.com/t5/QlikView/Working-with-timestamps/m-p/1254832#M625048 <HTML><HEAD></HEAD><BODY><P>See this discussion: <A href="https://community.qlik.com/thread/190964">Task/Ticket Duration</A>‌</P><P>or this one: <A href="https://community.qlik.com/thread/60227">Calculate hours between two Date/Time strings</A></P></BODY></HTML> Tue, 15 Nov 2016 16:50:40 GMT https://community.qlik.com/t5/QlikView/Working-with-timestamps/m-p/1254832#M625048 Gysbert_Wassenaar 2016-11-15T16:50:40Z