Text to time data format conversion error

[Anonymous]

Hi All,

I am using data imported from text file. One of the column has time value "mm:ss.0" which is considered as text.

I am trying to convert the same to time format but it gives me an error. I have only time values in volumn not date and time.

Error Message after ConversionActual time value as text in column

I am new to Power BI and any help will be helpful!

Thanks,
Rax

[v-jiascu-msft · Accepted solution]

Hi Rax,

Actually, the mm:ss isn't a valid time format. It's better to call it duration. I would suggest you add one step to replace these values and then change the format to Time. Please refer to the snapshot below.

#"Replaced Value" = Table.ReplaceValue(Source,each [Time],each "00:" & Text.Middle([Time], 0, 5),Replacer.ReplaceText,{"Time"}),

Best Regards,
Dale