https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595068#M7622 <P>Column2-Column1</P> Mon, 24 Jun 2019 11:49:41 GMT m_woolf 2019-06-24T11:49:41Z https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595046#M7621 <P>I HAVE A TWO DECIMAL COLUMN&nbsp; AND STORING TIME IN IT. LIKE AS FOLLOWS.&nbsp;&nbsp;</P><P>COLUMN 1&nbsp; &nbsp; &nbsp; &nbsp;COLUMN2</P><P>&nbsp; 06:50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;07.15</P><P>&nbsp; 07:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09.30</P><P>&nbsp;</P><P>How i can find the difference between these two time columns</P><P>&nbsp;</P> Fri, 02 Apr 2021 08:35:15 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595046#M7621 santhoshananad 2021-04-02T08:35:15Z https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595068#M7622 <P>Column2-Column1</P> Mon, 24 Jun 2019 11:49:41 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595068#M7622 m_woolf 2019-06-24T11:49:41Z https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595075#M7623 <P>not work like that. following is my formula</P><P>time(interval(time1-Interval(time2-time3,'hh:mm'),'hh:mm'))</P><P>time format is&nbsp; &nbsp; 05:25 like that</P><P>&nbsp;</P> Mon, 24 Jun 2019 11:54:49 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Time-Difference/m-p/1595075#M7623 santhoshananad 2019-06-24T11:54:49Z