https://community.qlik.com/t5/QlikView/Hours-between-TIMESTAMPS-not-coming-correct/m-p/1596789#M737245 <P>Hello Experts ,</P><P>&nbsp;</P><P>Hours between TIMESTAMPS not coming correct&nbsp; for me . Any advice on my first post .</P><P>&nbsp;</P><P>LOAD * ,</P><P>Round( (END- START )*24) as DurationInHours ;</P><P>LOAD * INLINE [<BR />START, END<BR />3/28/2019 11:00:00 PM, 3/28/2019 12:00:00 AM<BR />];</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ts1.PNG" style="width: 407px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14559i0726D66B0A337093/image-size/large?v=v2&amp;px=999" role="button" title="ts1.PNG" alt="ts1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ts2.PNG" style="width: 987px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14560i731DD7071D7A831D/image-size/large?v=v2&amp;px=999" role="button" title="ts2.PNG" alt="ts2.PNG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT alina_qlik 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Hours-between-TIMESTAMPS-not-coming-correct/m-p/1596789#M737245 <P>Hello Experts ,</P><P>&nbsp;</P><P>Hours between TIMESTAMPS not coming correct&nbsp; for me . Any advice on my first post .</P><P>&nbsp;</P><P>LOAD * ,</P><P>Round( (END- START )*24) as DurationInHours ;</P><P>LOAD * INLINE [<BR />START, END<BR />3/28/2019 11:00:00 PM, 3/28/2019 12:00:00 AM<BR />];</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ts1.PNG" style="width: 407px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14559i0726D66B0A337093/image-size/large?v=v2&amp;px=999" role="button" title="ts1.PNG" alt="ts1.PNG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ts2.PNG" style="width: 987px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14560i731DD7071D7A831D/image-size/large?v=v2&amp;px=999" role="button" title="ts2.PNG" alt="ts2.PNG" /></span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hours-between-TIMESTAMPS-not-coming-correct/m-p/1596789#M737245 alina_qlik 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Hours-between-TIMESTAMPS-not-coming-correct/m-p/1596892#M737246 <P>It looks like 12:00 AM is the morning of 3/28 not midnight.</P> Thu, 27 Jun 2019 16:15:37 GMT https://community.qlik.com/t5/QlikView/Hours-between-TIMESTAMPS-not-coming-correct/m-p/1596892#M737246 m_woolf 2019-06-27T16:15:37Z