topic Split the time one hour to one hour in App Development https://community.qlik.com/t5/App-Development/Split-the-time-one-hour-to-one-hour/m-p/1818772#M67120 <P>Hi All,</P><P>I have a data given below screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_0-1625041246933.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57758iA23B8C2E6479E57A/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_0-1625041246933.png" alt="dineshm030_0-1625041246933.png" /></span></P><TABLE><TBODY><TR><TD>ID</TD><TD>StartDateUTC</TD><TD>EndDateUTC</TD><TD>IPAddress</TD><TD>ReasonCode</TD></TR><TR><TD>95634D78-64CE-43B3-B430-0926A9DEDEA5</TD><TD>07-06-2021 15:27</TD><TD>07-06-2021 20:28</TD><TD>10.22.33.70</TD><TD>112</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The requirement is have to take time difference between StartDate and EndDate field. The overall time diff is 5:0:10.&nbsp;</P><P>I have to split the data like this:</P><TABLE><TBODY><TR><TD>StartTime</TD><TD>EndTime</TD><TD>Downtime in Mins</TD></TR><TR><TD>00:00</TD><TD>01:00</TD><TD>0</TD></TR><TR><TD>01:00</TD><TD>02:00</TD><TD>0</TD></TR><TR><TD>02:00</TD><TD>03:00</TD><TD>0</TD></TR><TR><TD>03:00</TD><TD>04:00</TD><TD>0</TD></TR><TR><TD>04:00</TD><TD>05:00</TD><TD>0</TD></TR><TR><TD>05:00</TD><TD>06:00</TD><TD>0</TD></TR><TR><TD>06:00</TD><TD>07:00</TD><TD>0</TD></TR><TR><TD>07:00</TD><TD>08:00</TD><TD>0</TD></TR><TR><TD>08:00</TD><TD>09:00</TD><TD>0</TD></TR><TR><TD>09:00</TD><TD>10:00</TD><TD>0</TD></TR><TR><TD>10:00</TD><TD>11:00</TD><TD>0</TD></TR><TR><TD>11:00</TD><TD>12:00</TD><TD>0</TD></TR><TR><TD>12:00</TD><TD>13:00</TD><TD>0</TD></TR><TR><TD>13:00</TD><TD>14:00</TD><TD>0</TD></TR><TR><TD>14:00</TD><TD>15:00</TD><TD>0</TD></TR><TR><TD>15:00</TD><TD>16:00</TD><TD>33</TD></TR><TR><TD>16:00</TD><TD>17:00</TD><TD>60</TD></TR><TR><TD>17:00</TD><TD>18:00</TD><TD>60</TD></TR><TR><TD>18:00</TD><TD>19:00</TD><TD>60</TD></TR><TR><TD>19:00</TD><TD>20:00</TD><TD>60</TD></TR><TR><TD>20:00</TD><TD>21:00</TD><TD>32</TD></TR><TR><TD>21:00</TD><TD>22:00</TD><TD>0</TD></TR><TR><TD>22:00</TD><TD>23:00</TD><TD>0</TD></TR><TR><TD>23:00</TD><TD>00:00</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance.&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17935">@MayilVahanan</a>&nbsp;&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp; &nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28038">@marcus_sommer</a>&nbsp;</P><P>Regards,</P><P>Dinesh.</P> Tue, 30 Nov 2021 18:17:33 GMT dineshm030 2021-11-30T18:17:33Z Split the time one hour to one hour https://community.qlik.com/t5/App-Development/Split-the-time-one-hour-to-one-hour/m-p/1818772#M67120 <P>Hi All,</P><P>I have a data given below screenshot.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="dineshm030_0-1625041246933.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57758iA23B8C2E6479E57A/image-size/medium?v=v2&amp;px=400" role="button" title="dineshm030_0-1625041246933.png" alt="dineshm030_0-1625041246933.png" /></span></P><TABLE><TBODY><TR><TD>ID</TD><TD>StartDateUTC</TD><TD>EndDateUTC</TD><TD>IPAddress</TD><TD>ReasonCode</TD></TR><TR><TD>95634D78-64CE-43B3-B430-0926A9DEDEA5</TD><TD>07-06-2021 15:27</TD><TD>07-06-2021 20:28</TD><TD>10.22.33.70</TD><TD>112</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The requirement is have to take time difference between StartDate and EndDate field. The overall time diff is 5:0:10.&nbsp;</P><P>I have to split the data like this:</P><TABLE><TBODY><TR><TD>StartTime</TD><TD>EndTime</TD><TD>Downtime in Mins</TD></TR><TR><TD>00:00</TD><TD>01:00</TD><TD>0</TD></TR><TR><TD>01:00</TD><TD>02:00</TD><TD>0</TD></TR><TR><TD>02:00</TD><TD>03:00</TD><TD>0</TD></TR><TR><TD>03:00</TD><TD>04:00</TD><TD>0</TD></TR><TR><TD>04:00</TD><TD>05:00</TD><TD>0</TD></TR><TR><TD>05:00</TD><TD>06:00</TD><TD>0</TD></TR><TR><TD>06:00</TD><TD>07:00</TD><TD>0</TD></TR><TR><TD>07:00</TD><TD>08:00</TD><TD>0</TD></TR><TR><TD>08:00</TD><TD>09:00</TD><TD>0</TD></TR><TR><TD>09:00</TD><TD>10:00</TD><TD>0</TD></TR><TR><TD>10:00</TD><TD>11:00</TD><TD>0</TD></TR><TR><TD>11:00</TD><TD>12:00</TD><TD>0</TD></TR><TR><TD>12:00</TD><TD>13:00</TD><TD>0</TD></TR><TR><TD>13:00</TD><TD>14:00</TD><TD>0</TD></TR><TR><TD>14:00</TD><TD>15:00</TD><TD>0</TD></TR><TR><TD>15:00</TD><TD>16:00</TD><TD>33</TD></TR><TR><TD>16:00</TD><TD>17:00</TD><TD>60</TD></TR><TR><TD>17:00</TD><TD>18:00</TD><TD>60</TD></TR><TR><TD>18:00</TD><TD>19:00</TD><TD>60</TD></TR><TR><TD>19:00</TD><TD>20:00</TD><TD>60</TD></TR><TR><TD>20:00</TD><TD>21:00</TD><TD>32</TD></TR><TR><TD>21:00</TD><TD>22:00</TD><TD>0</TD></TR><TR><TD>22:00</TD><TD>23:00</TD><TD>0</TD></TR><TR><TD>23:00</TD><TD>00:00</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance.&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/17935">@MayilVahanan</a>&nbsp;&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp; &nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28038">@marcus_sommer</a>&nbsp;</P><P>Regards,</P><P>Dinesh.</P> Tue, 30 Nov 2021 18:17:33 GMT https://community.qlik.com/t5/App-Development/Split-the-time-one-hour-to-one-hour/m-p/1818772#M67120 dineshm030 2021-11-30T18:17:33Z