Duration

[jingwen]

Hi,

I need to convert the duration to hh:mm. The format in excel is already [h]:mm. I cannot use datediff because the values for verified downtime will be from different columns. Can someone please help me. 

Thanks. 

[olgad]

Hey, if the fiormat is already in h:mm how does it get picked up by power bi initially? go to the first change type under the applied steps, see what is the datatype for that column there, click on duration data type being on the step, add new step then replace the current step and see if it helps.