https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Time-to-Seconds-Conversion/m-p/705914#M917 <P>Hi All Power BI Gurus,</P><P>I need help in calculating the difference in times in MM:SS format. I have two columns with times (Time1 and Time2) and I want the difference these two times in a new column (Time Diff). I'm very new to power BI and I'm learning dashboard. Please help me with this formating issue as well. I tried duration.totext and also DATEDIFF but I didn't get any results, it was giving me some syntax error.&nbsp;</P><P>&nbsp;</P><P>Time1 &nbsp; &nbsp;&nbsp; Time2 &nbsp; &nbsp; &nbsp;&nbsp; Time Diff<BR />1:20:05 &nbsp;&nbsp; 1:30:05 &nbsp; &nbsp; &nbsp; 10:00<BR />13:10:00&nbsp; 13:20:50 &nbsp; &nbsp; 10:30</P><P>&nbsp;</P><P>Thank you,</P><P>M</P> Mon, 03 Jun 2019 20:58:41 GMT malathi 2019-06-03T20:58:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Time-to-Seconds-Conversion/m-p/705914#M917 <P>Hi All Power BI Gurus,</P><P>I need help in calculating the difference in times in MM:SS format. I have two columns with times (Time1 and Time2) and I want the difference these two times in a new column (Time Diff). I'm very new to power BI and I'm learning dashboard. Please help me with this formating issue as well. I tried duration.totext and also DATEDIFF but I didn't get any results, it was giving me some syntax error.&nbsp;</P><P>&nbsp;</P><P>Time1 &nbsp; &nbsp;&nbsp; Time2 &nbsp; &nbsp; &nbsp;&nbsp; Time Diff<BR />1:20:05 &nbsp;&nbsp; 1:30:05 &nbsp; &nbsp; &nbsp; 10:00<BR />13:10:00&nbsp; 13:20:50 &nbsp; &nbsp; 10:30</P><P>&nbsp;</P><P>Thank you,</P><P>M</P> Mon, 03 Jun 2019 20:58:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Time-to-Seconds-Conversion/m-p/705914#M917 malathi 2019-06-03T20:58:41Z