https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670044#M50623 <P>Hi!</P><P>I added the expression (<FONT color="#FF0000">New</FONT>) to my table but the result doesn't seems to be correct.</P><P>The 'response_time_bh' is calculated in the load script. I don't know if this matters?</P><TABLE><TBODY><TR><TD>Ticket ID</TD><TD>response_time_bh</TD><TD><FONT color="#FF0000">New</FONT></TD></TR><TR><TD>OP-000001700301</TD><TD>102:01:45</TD><TD>4,25</TD></TR><TR><TD>OP-000001697522</TD><TD>03:19:41</TD><TD>0,14</TD></TR><TR><TD>OP-000001689558</TD><TD>05:03:43</TD><TD>0,21</TD></TR><TR><TD>OP-000001665107</TD><TD>294:53:39</TD><TD>12,29</TD></TR><TR><TD>OP-000001655877</TD><TD>318:23:34</TD><TD>13,27</TD></TR><TR><TD>OP-000001653706</TD><TD>312:21:46</TD><TD>13,02</TD></TR><TR><TD>OP-000001653705</TD><TD>314:22:29</TD><TD>13,10</TD></TR></TBODY></TABLE> Tue, 28 Jan 2020 13:30:45 GMT stekol61 2020-01-28T13:30:45Z https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670036#M50620 <P>Hi!</P><P>I want to convert the timestamps below to hours.</P><P>I tried to use the Hour() expression but i doesn't seem to work when hour part is higher than 24h.</P><P>Any idea how to solve this?</P><TABLE><TBODY><TR><TD>Ticket ID</TD><TD>response_time_bh</TD></TR><TR><TD>OP-000001700301</TD><TD>102:01:45</TD></TR><TR><TD>OP-000001697522</TD><TD>03:19:41</TD></TR><TR><TD>OP-000001689558</TD><TD>05:03:43</TD></TR><TR><TD>OP-000001665107</TD><TD>278:34:00</TD></TR><TR><TD>OP-000001655877</TD><TD>302:03:55</TD></TR><TR><TD>OP-000001653706</TD><TD>296:02:07</TD></TR></TBODY></TABLE> Tue, 28 Jan 2020 13:07:25 GMT https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670036#M50620 stekol61 2020-01-28T13:07:25Z https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670037#M50621 <P>Try this expression:</P><P><FONT face="courier new,courier">=interval(interval#([<SPAN>response_time_bh]</SPAN>, 'hh:mm:ss'),'h')</FONT></P> Tue, 28 Jan 2020 13:12:33 GMT https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670037#M50621 Vegar 2020-01-28T13:12:33Z https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670044#M50623 <P>Hi!</P><P>I added the expression (<FONT color="#FF0000">New</FONT>) to my table but the result doesn't seems to be correct.</P><P>The 'response_time_bh' is calculated in the load script. I don't know if this matters?</P><TABLE><TBODY><TR><TD>Ticket ID</TD><TD>response_time_bh</TD><TD><FONT color="#FF0000">New</FONT></TD></TR><TR><TD>OP-000001700301</TD><TD>102:01:45</TD><TD>4,25</TD></TR><TR><TD>OP-000001697522</TD><TD>03:19:41</TD><TD>0,14</TD></TR><TR><TD>OP-000001689558</TD><TD>05:03:43</TD><TD>0,21</TD></TR><TR><TD>OP-000001665107</TD><TD>294:53:39</TD><TD>12,29</TD></TR><TR><TD>OP-000001655877</TD><TD>318:23:34</TD><TD>13,27</TD></TR><TR><TD>OP-000001653706</TD><TD>312:21:46</TD><TD>13,02</TD></TR><TR><TD>OP-000001653705</TD><TD>314:22:29</TD><TD>13,10</TD></TR></TBODY></TABLE> Tue, 28 Jan 2020 13:30:45 GMT https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670044#M50623 stekol61 2020-01-28T13:30:45Z https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670097#M50628 <P>the <FONT color="#FF0000">New</FONT> expression is showing the underlying numeric value of the interval. 102:01:45 is 4,25 days.</P><P>To format the <FONT color="#FF0000">New</FONT> back to no of hours do this</P><P><FONT face="courier new,courier">=interval(<FONT color="#FF0000">New</FONT>, 'h')</FONT></P> Tue, 28 Jan 2020 15:06:12 GMT https://community.qlik.com/t5/App-Development/Convert-hh-mm-ss-to-hours/m-p/1670097#M50628 Vegar 2020-01-28T15:06:12Z