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.

Syntax

TIMEVALUE(time_text)

time_text A time which has formatted as a text which you want to convert into a valid time value.

More Information on Excel TIMEVALUE Function

You can provide a text format which excel can recognize.

It will convert text into a decimal number which represents time.

Examples

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.

Sample File

What’s Next?

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.