topic Workinghours - How to do this ? in QlikView https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148581#M504687 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P>I have the following raw data:</P><TABLE><TBODY><TR><TH>EmployeeNumber</TH><TH>EmployeeName</TH><TH>TypeCode</TH><TH>TimeStart</TH><TH>TimeEnd</TH></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Break1</TD><TD>09:00</TD><TD>09:15</TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Break2</TD><TD></TD><TD></TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Lunch</TD><TD>12:00</TD><TD>13:00</TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>WorkingHours</TD><TD>07:00</TD><TD>16:00</TD></TR></TBODY></TABLE><P>and I want this result</P><TABLE><TBODY><TR><TH>EmployeeNumber</TH><TH>EmployeeName</TH><TH>TotalWorkTime</TH></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>07:45</TD></TR></TBODY></TABLE><P>TotalWorkTime is Workinghours minus Lunch minus Break1&amp;2</P><P>Any ideas ?</P><P>I attach a sample.</P><P>/Pär</P><P></P></BODY></HTML> Mon, 06 Jul 2009 19:26:06 GMT separerl 2009-07-06T19:26:06Z Workinghours - How to do this ? https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148581#M504687 <HTML><HEAD></HEAD><BODY><P>Hi !</P><P>I have the following raw data:</P><TABLE><TBODY><TR><TH>EmployeeNumber</TH><TH>EmployeeName</TH><TH>TypeCode</TH><TH>TimeStart</TH><TH>TimeEnd</TH></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Break1</TD><TD>09:00</TD><TD>09:15</TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Break2</TD><TD></TD><TD></TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>Lunch</TD><TD>12:00</TD><TD>13:00</TD></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>WorkingHours</TD><TD>07:00</TD><TD>16:00</TD></TR></TBODY></TABLE><P>and I want this result</P><TABLE><TBODY><TR><TH>EmployeeNumber</TH><TH>EmployeeName</TH><TH>TotalWorkTime</TH></TR><TR><TD>158</TD><TD>Donald Duck</TD><TD>07:45</TD></TR></TBODY></TABLE><P>TotalWorkTime is Workinghours minus Lunch minus Break1&amp;2</P><P>Any ideas ?</P><P>I attach a sample.</P><P>/Pär</P><P></P></BODY></HTML> Mon, 06 Jul 2009 19:26:06 GMT https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148581#M504687 separerl 2009-07-06T19:26:06Z Workinghours - How to do this ? https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148582#M504688 <HTML><HEAD></HEAD><BODY><P>Here is something that can help ( I hope )</P><P></P><P>Philippe</P><P></P></BODY></HTML> Mon, 06 Jul 2009 20:13:56 GMT https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148582#M504688 2009-07-06T20:13:56Z Workinghours - How to do this ? https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148583#M504689 <HTML><HEAD></HEAD><BODY><P>Hi Philippe !</P><P>This works like a dream !</P><P>Thanks a lot for your help !!</P><P>/Pär</P><P></P></BODY></HTML> Mon, 06 Jul 2009 21:15:34 GMT https://community.qlik.com/t5/QlikView/Workinghours-How-to-do-this/m-p/148583#M504689 separerl 2009-07-06T21:15:34Z