However, the TIME function still works properly, coercing the text values to numbers automatically.
The TIME function is useful when you want to assemble a proper time inside another formula.
For example, =MID(“apple”,2,3) returns “ppl”.
Convert text timestamp into time
Top convert a timestamp entered as text into a proper Excel time, you can use the MID function to extract components and the TIME function to assemble the time. In the example shown, the formula in F5 is: =TIME(MID(B5,1,2),MID(B5,4,2),MID(B5,7,2))
