If your data is always like that, i.e. time information occupying the
last 5 characters of the string, then you can do this, assuming the
data is in cell A1:

=VALUE(RIGHT(A1,5)&":00")

and format the cell with the formula in as hh:mm.

Hope this helps.

Pete