topic Re: Add seconds in QlikView https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102286#M904874 <HTML><HEAD></HEAD><BODY><P>Tnx a lot.</P><P>works properly</P></BODY></HTML> Thu, 23 Jun 2016 14:03:07 GMT 2016-06-23T14:03:07Z Add seconds https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102283#M904871 <HTML><HEAD></HEAD><BODY><P>Hi there</P><P>I have a problem in using time function in qlikview; assume that i have a variable that keeps Num of&nbsp; now time in itself.I need to add 1 second to this number and again convert it to time format.which number can add one second to the number?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102283#M904871 2020-11-25T16:16:04Z Re: Add seconds https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102284#M904872 <HTML><HEAD></HEAD><BODY><P>Well,</P><P></P><P>given that under the hood QlikView stores each date as a floating point number, and there are 86400 seconds in a day</P><P></P><P>just add 1/86400 to your time</P><P></P><P>Marcus</P></BODY></HTML> Thu, 23 Jun 2016 13:46:59 GMT https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102284#M904872 marcus_malinow 2016-06-23T13:46:59Z Re: Add seconds https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102285#M904873 <HTML><HEAD></HEAD><BODY><P>Or you can add like this:</P><P></P><P><STRONG>Time(FieldName + MakeTime(0, 0, 1))</STRONG></P></BODY></HTML> Thu, 23 Jun 2016 13:53:38 GMT https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102285#M904873 sunny_talwar 2016-06-23T13:53:38Z Re: Add seconds https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102286#M904874 <HTML><HEAD></HEAD><BODY><P>Tnx a lot.</P><P>works properly</P></BODY></HTML> Thu, 23 Jun 2016 14:03:07 GMT https://community.qlik.com/t5/QlikView/Add-seconds/m-p/1102286#M904874 2016-06-23T14:03:07Z