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 recongnise as a time.
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.
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 MID Function you can check Microsoft’s Help Section.
And, if you have a unique idea to use timevalue function, I would love to hear from you.
There are also some functions like DATEVALUE which is highly useful.