Formatting Text Time

Hi everyone. I'm trying to convert a text column that houses TIME information and convert it to show hour, but all the functions I use don't seem to be working. I tried making a measure and columns, ...