Try identifying the possible formats and interpretations. For example, for shown data, try something like this:
select *,
try_cast(case when MyColumn like '[0-9][0-9]:[0-9][0-9].[0-9]%' then '00:' + MyColumn else MyColumn end as time(0)) as [Time]
from MyTable
Show details if there are more cases.