title: Power BI convert both HH:MM:SS format and decimal duration format to MM:SS format
body: <p>PLease review the screenshot.</p>
  <p><a href="https://i.stack.imgur.com/8jGcL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8jGcL.png" alt="enter image description here" /></a></p>
  <p>The column contains both HH:MM:SS format and decimal duration in hours format with extra leading zeros. They are both in Text format.</p>
  <p>How to covert them to MM:SS format? Like for example 01:28:10 should be 88:10</p>
  <p>I'm quite confused by how to achieve that by using DAX.</p>
  <p>I have tried multiple possible solutions but none worked.</p>