I have a column i would like to convert from text mm:ss to Time hh:mm:ss
Go to Solution.
You can also do this in Power Query with a new column:
Text.PadStart ("00:",1) ,
Have you tried CombineValues / TimeValue ?
CombineValues("00:",Text) = This will remain as text
TimeValue(text) = will convert text to Time