If you want to convert a time value which is stored as a text you can use TIMEVALUE Function. It can convert a time which is in a textual format into a valid time.
When you refer to a text value, it will return a numeric value which excel can recognize as a valid time.
If you use a textual time value which has no am/pm in it, the function will return a serial number which represents time in 24-hour format. You can change format of serial number to get the time
Timevalue function will convert any textual time value which is recognizable by excel in the decimal number. As 12:00 AM is the starting time of a day, the function has return 0 for it.
Timevalue will return a decimal number ranging from 0 to 1 represents the time from 12:00 am To 11:59 pm.
Timevalue is smart enough to get the time from a date if that date has time in it. While using timevalue function all you have to take care is, a textual date should be a date which can recognizable by excel.
To learn more about Excel TIMEVALUE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.