topic Intervals entry - output in QlikView https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559283#M441136 <P>Hey guys! How r u? I have a data like DATA excel attached, and i m looking for a solution like this table</P><TABLE><TBODY><TR><TD>ef_name</TD><TD>in</TD><TD>out</TD><TD>Dif hh:mm</TD><TD>Total hh:mm</TD><TD>Out time hh:mm</TD><TD>Total Out Time&nbsp;</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 12:09</TD><TD>29/01/2015 16:13</TD><TD>04:04:00</TD><TD>06:51:00</TD><TD>-</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 16:16</TD><TD>29/01/2015 16:21</TD><TD>00:05:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 16:24</TD><TD>29/01/2015 16:56</TD><TD>00:32:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:00</TD><TD>29/01/2015 17:15</TD><TD>00:15:00</TD><TD>06:51:00</TD><TD>00:04:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:18</TD><TD>29/01/2015 17:50</TD><TD>00:32:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:53</TD><TD>29/01/2015 18:06</TD><TD>00:13:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 18:09</TD><TD>29/01/2015 19:19</TD><TD>01:10:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 07:08</TD><TD>06/03/2019 08:31</TD><TD>01:23:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:37</TD><TD>06/03/2019 08:50</TD><TD>00:13:00</TD><TD>04:39:00</TD><TD>00:06:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:50</TD><TD>06/03/2019 08:51</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:52</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:02</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:32</TD><TD>06/03/2019 09:36</TD><TD>00:04:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:36</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:58</TD><TD>06/03/2019 09:59</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:05</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:25</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:46</TD><TD>06/03/2019 10:49</TD><TD>00:03:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:02</TD><TD>06/03/2019 11:11</TD><TD>00:09:00</TD><TD>04:39:00</TD><TD>00:13:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:16</TD><TD>06/03/2019 11:16</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:19</TD><TD>06/03/2019 11:19</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:03:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:21</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:24</TD><TD>06/03/2019 11:53</TD><TD>00:29:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:58</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:00</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:05</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:07</TD><TD>06/03/2019 12:47</TD><TD>00:40:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:52</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:07</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:11</TD><TD>06/03/2019 13:38</TD><TD>00:27:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:51</TD><TD>06/03/2019 13:51</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:13:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:01</TD><TD>06/03/2019 14:02</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:10:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:02</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:10</TD><TD>06/03/2019 14:11</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:11</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:14</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:16</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:18</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:20</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:23</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:26</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:27</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:28</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:29</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:32</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:33</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:34</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:35</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:36</TD><TD>06/03/2019 14:37</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:38</TD><TD>06/03/2019 14:38</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:39</TD><TD>06/03/2019 14:40</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:40</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:42</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:43</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:44</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:45</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:46</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:54</TD><TD>06/03/2019 15:00</TD><TD>00:06:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:02</TD><TD>06/03/2019 15:04</TD><TD>00:02:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:06</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:10</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:11</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:12</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:13</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:14</TD><TD>06/03/2019 15:31</TD><TD>00:17:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:34</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:03:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:37</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:38</TD><TD>06/03/2019 15:39</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:41</TD><TD>06/03/2019 15:41</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:46</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:48</TD><TD>06/03/2019 16:27</TD><TD>00:39:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is It possible?</P><P>&nbsp;</P><P>Thanks!</P> Sat, 16 Nov 2024 21:12:33 GMT jumiprado 2024-11-16T21:12:33Z Intervals entry - output https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559283#M441136 <P>Hey guys! How r u? I have a data like DATA excel attached, and i m looking for a solution like this table</P><TABLE><TBODY><TR><TD>ef_name</TD><TD>in</TD><TD>out</TD><TD>Dif hh:mm</TD><TD>Total hh:mm</TD><TD>Out time hh:mm</TD><TD>Total Out Time&nbsp;</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 12:09</TD><TD>29/01/2015 16:13</TD><TD>04:04:00</TD><TD>06:51:00</TD><TD>-</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 16:16</TD><TD>29/01/2015 16:21</TD><TD>00:05:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 16:24</TD><TD>29/01/2015 16:56</TD><TD>00:32:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:00</TD><TD>29/01/2015 17:15</TD><TD>00:15:00</TD><TD>06:51:00</TD><TD>00:04:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:18</TD><TD>29/01/2015 17:50</TD><TD>00:32:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 17:53</TD><TD>29/01/2015 18:06</TD><TD>00:13:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 18:09</TD><TD>29/01/2015 19:19</TD><TD>01:10:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 07:08</TD><TD>06/03/2019 08:31</TD><TD>01:23:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:37</TD><TD>06/03/2019 08:50</TD><TD>00:13:00</TD><TD>04:39:00</TD><TD>00:06:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:50</TD><TD>06/03/2019 08:51</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 08:52</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:02</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:32</TD><TD>06/03/2019 09:36</TD><TD>00:04:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:36</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 09:58</TD><TD>06/03/2019 09:59</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:05</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:25</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 10:46</TD><TD>06/03/2019 10:49</TD><TD>00:03:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:02</TD><TD>06/03/2019 11:11</TD><TD>00:09:00</TD><TD>04:39:00</TD><TD>00:13:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:16</TD><TD>06/03/2019 11:16</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:19</TD><TD>06/03/2019 11:19</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:03:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:21</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:24</TD><TD>06/03/2019 11:53</TD><TD>00:29:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 11:58</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:00</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:05</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:07</TD><TD>06/03/2019 12:47</TD><TD>00:40:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 12:52</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:07</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:11</TD><TD>06/03/2019 13:38</TD><TD>00:27:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 13:51</TD><TD>06/03/2019 13:51</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:13:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:01</TD><TD>06/03/2019 14:02</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:10:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:02</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:10</TD><TD>06/03/2019 14:11</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:11</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:14</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:16</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:17</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:18</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:20</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:23</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:26</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:27</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:28</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:29</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:32</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:33</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:34</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:35</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:36</TD><TD>06/03/2019 14:37</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:38</TD><TD>06/03/2019 14:38</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:39</TD><TD>06/03/2019 14:40</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:40</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:00:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:42</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:43</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:44</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:45</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:46</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 14:54</TD><TD>06/03/2019 15:00</TD><TD>00:06:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:01</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:01:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:02</TD><TD>06/03/2019 15:04</TD><TD>00:02:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:06</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:10</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:11</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:12</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:13</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:14</TD><TD>06/03/2019 15:31</TD><TD>00:17:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:34</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:03:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:37</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:38</TD><TD>06/03/2019 15:39</TD><TD>00:01:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:41</TD><TD>06/03/2019 15:41</TD><TD>00:00:00</TD><TD>04:39:00</TD><TD>00:02:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:46</TD><TD>&nbsp;</TD><TD>Error</TD><TD>04:39:00</TD><TD>00:05:00</TD><TD>01:37:00</TD></TR><TR><TD>Agent 2</TD><TD>06/03/2019 15:48</TD><TD>06/03/2019 16:27</TD><TD>00:39:00</TD><TD>04:39:00</TD><TD>Error</TD><TD>01:37:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Is It possible?</P><P>&nbsp;</P><P>Thanks!</P> Sat, 16 Nov 2024 21:12:33 GMT https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559283#M441136 jumiprado 2024-11-16T21:12:33Z Re: Intervals entry - output https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559314#M441138 Yes, it is possible but can you tell us how the last two columns are calculated? Wed, 20 Mar 2019 23:07:51 GMT https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559314#M441138 tincholiver 2019-03-20T23:07:51Z Re: Intervals entry - output https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559319#M441139 <P>of course, thanks for answer!</P><P>the field Out Time is the difference between the previous out and the next "in" for each Agent and for each day. in the example the first row dont have it because the day starts at the first row, but the second row yes.</P><P>For the Total Out time is the sum for each agent each day, so i need to calculate how much time is each agent out and sum that per day!</P><TABLE><TBODY><TR><TD>ef_name</TD><TD>in</TD><TD>out</TD><TD>Dif hh:mm</TD><TD>Total hh:mm</TD><TD>Out time hh:mm</TD><TD>Total Out Time&nbsp;</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 12:09</TD><TD>29/01/2015 16:13</TD><TD>04:04:00</TD><TD>06:51:00</TD><TD>-</TD><TD>00:19:00</TD></TR><TR><TD>Agent 1</TD><TD>29/01/2015 16:16</TD><TD>29/01/2015 16:21</TD><TD>00:05:00</TD><TD>06:51:00</TD><TD>00:03:00</TD><TD>00:19:00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>i hope i was clear!</P><P>&nbsp;</P><P>Thanks again!</P> Thu, 21 Mar 2019 00:03:40 GMT https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559319#M441139 jumiprado 2019-03-21T00:03:40Z Re: Intervals entry - output https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559917#M441221 <P>Please check the attached</P> Fri, 22 Mar 2019 06:51:53 GMT https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1559917#M441221 anushree1 2019-03-22T06:51:53Z Re: Intervals entry - output https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1560091#M441230 Thank you very much Anushree,<BR />I hope it is the solution that Jumiprado is looking for. Fri, 22 Mar 2019 13:05:25 GMT https://community.qlik.com/t5/QlikView/Intervals-entry-output/m-p/1560091#M441230 tincholiver 2019-03-22T13:05:25Z