cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CraigDykes Regular Visitor
Regular Visitor

Convert text mm:ss to Time hh:mm:ss

I have a column i would like to convert from text mm:ss to Time hh:mm:ss

 

E.g                               

  (Curent)Text            Time                        

09:50                      00:09:50    

15:17                       00:15:17

 

Thanks,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nick_M New Contributor
New Contributor

Re: Convert text mm:ss to Time hh:mm:ss

You can also do this in Power Query with a new column:

Text.Combine
(
    {
        Text.PadStart ("00:",1) , 
        Text.From([Text])
    }
)

PadStart.png

2 REPLIES 2
Jorgast Regular Visitor
Regular Visitor

Re: Convert text mm:ss to Time hh:mm:ss

Have you tried CombineValues / TimeValue ?

 

CombineValues("00:",Text) = This will remain as text

TimeValue(text) = will convert text to Time 

 

https://docs.microsoft.com/en-us/dax/timevalue-function-dax

Nick_M New Contributor
New Contributor

Re: Convert text mm:ss to Time hh:mm:ss

You can also do this in Power Query with a new column:

Text.Combine
(
    {
        Text.PadStart ("00:",1) , 
        Text.From([Text])
    }
)

PadStart.png