Convert two datatypes in one column to one

[pvancha]

Hi, I am relatively new to Power BI and am trying to convert two data types from one column to one. I have a column called ACD Time and some of the values are in time format(hh:mm:ss) and some of it has been converted to decimal numbers at the source. When I try to convert this column into time format, the decimal numbers are formatted correctly, but I am getting an error for values in (hh:mm:ss) format. Is there a way to compete this formatting process for all values.

 and after formatting these are the errors

[Fowmy · Accepted solution]

@pvancha 

Click on custom Column and add the following code

try Time.From(Number.From([123 AUX Time])) otherwise Time.From([123 AUX Time])

[pvancha · Accepted solution]

Thanks, It worked.

[Fowmy · Accepted solution]

@pvancha 

Click on custom Column and add the following code

try Time.From(Number.From([123 AUX Time])) otherwise Time.From([123 AUX Time])