topic Re: Issues with my TimeStamp in QlikView https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913634#M985440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check the qvw</P><P>Hope it helps you..</P><P></P><P></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Fri, 07 Aug 2015 06:38:57 GMT kavita25 2015-08-07T06:38:57Z Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913627#M985433 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I am trying to calculate a difference between 2 timestamps and I have issues to obtain values with ny Timestamp format.</P><P>What I want to end up with is a duration in hours between the minimum values of my first time stamp of the day and the last one so that i Can work with the number of actual working hours.<BR />Here is my table. if you want to have a look at it.</P><P>Thx you very much already.<BR />Alexandre BERNARD</P></BODY></HTML> Thu, 06 Aug 2015 12:06:47 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913627#M985433 2015-08-06T12:06:47Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913628#M985434 <HTML><HEAD></HEAD><BODY><P>Your excel file is unable to open...Reattached the file.</P><P></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Thu, 06 Aug 2015 12:16:17 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913628#M985434 kavita25 2015-08-06T12:16:17Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913629#M985435 <HTML><HEAD></HEAD><BODY><P>Hi try using floor,</P><P></P><P>((Floor((MP_TO_DT))-(Floor(MP_FM_DT))))</P></BODY></HTML> Thu, 06 Aug 2015 12:36:36 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913629#M985435 krishna20 2015-08-06T12:36:36Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913630#M985436 <HTML><HEAD></HEAD><BODY><P>You can Use Interval function...</P><P>(Interval((<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">MP_TO_DT</SPAN>)-(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">MP_FM_DT</SPAN>),'h:m'))</P><P></P><P>Somewhat lyk dis..for futher understanding..attached the document.</P><P></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Thu, 06 Aug 2015 12:42:23 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913630#M985436 kavita25 2015-08-06T12:42:23Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913631#M985437 <HTML><HEAD></HEAD><BODY><P>First you will need to convert your TIMESTMP to TimeStamp format and the date Fileld <STRONG>Date</STRONG> to.</P><P></P><P>TimeStamp(Date#(TIMESTMP, 'MM/DD/YYYY-hhmmss')) as TIMESTMP</P><P>Date(Date#(Date, 'YYYY-MM-DD')) as Date</P><P></P><P>The part i don't understand is:</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><EM>What I want to end up with is a duration in hours between the minimum values of my first time stamp of the day and the last one so that i Can work with the number of actual working hours.</EM></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Could you please elaborate?</P></BODY></HTML> Thu, 06 Aug 2015 12:54:11 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913631#M985437 maximiliano_vel 2015-08-06T12:54:11Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913632#M985438 <HTML><HEAD></HEAD><BODY><P>First of all thank you everyone for your answers !</P><P>What I meant Maximiliano&nbsp; is to be able to measure the duration between the 1st timestamp of the day and the last of the same day. With this duration I would be able to know how much hours of work there were actually during one day.</P></BODY></HTML> Thu, 06 Aug 2015 14:04:55 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913632#M985438 2015-08-06T14:04:55Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913633#M985439 <HTML><HEAD></HEAD><BODY><P>Please see attached file and tell me if this is what you need. Regards</P></BODY></HTML> Thu, 06 Aug 2015 14:20:34 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913633#M985439 maximiliano_vel 2015-08-06T14:20:34Z Re: Issues with my TimeStamp https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913634#M985440 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Check the qvw</P><P>Hope it helps you..</P><P></P><P></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Fri, 07 Aug 2015 06:38:57 GMT https://community.qlik.com/t5/QlikView/Issues-with-my-TimeStamp/m-p/913634#M985440 kavita25 2015-08-07T06:38:57Z