Microsoft Office Tutorials and References
In Depth Information
Using Functions for Non-English Character Sets
=TIME(0,LEFT(B2,1),RIGHT(B2,2)). You copy this formula down and
format the range as a time.
• The other solution is to use the concatenation operator to pad the
left of column B with 0:0. This allows the text to work in the
TIMEVALUE function. The formula in cell E2 is
=TIMEVALUE("0:0"&B2). Again, you need to copy this formula down
and format the range as a time.