topic Re: How to convert seconds into a number/integer in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486141#M181654 <HTML><HEAD></HEAD><BODY><P>Leave out the interval. Dates are numbers so simply subtracting two dates from each other will result in another number. If you want you can use the num function to specify a format: num(ScheArriv-ActualArrive,'#,###.00')</P></BODY></HTML> Wed, 19 Jun 2013 14:04:45 GMT Gysbert_Wassenaar 2013-06-19T14:04:45Z How to convert seconds into a number/integer https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486140#M181653 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>What do I need to do to this expression to convert it into a number?</P><P></P><P>Interval(SchedArriv-ActualArrive,'ss') .</P><P>I've tried a SUM and a NUM, but it returns incorrect values.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 19 Jun 2013 08:18:43 GMT https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486140#M181653 2013-06-19T08:18:43Z Re: How to convert seconds into a number/integer https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486141#M181654 <HTML><HEAD></HEAD><BODY><P>Leave out the interval. Dates are numbers so simply subtracting two dates from each other will result in another number. If you want you can use the num function to specify a format: num(ScheArriv-ActualArrive,'#,###.00')</P></BODY></HTML> Wed, 19 Jun 2013 14:04:45 GMT https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486141#M181654 Gysbert_Wassenaar 2013-06-19T14:04:45Z Re: How to convert seconds into a number/integer https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486142#M181655 <HTML><HEAD></HEAD><BODY><P>Thanks again, Gysbert! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 20 Jun 2013 09:53:41 GMT https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-a-number-integer/m-p/486142#M181655 2013-06-20T09:53:41Z