Excel Formulas to Parse Time String to Time ~ A Complete Tutorial!!

For instance, you have a list of a text string in a worksheet, and now you need to convert these text strings to time or date and time, how can you solve it? Here I will introduce some tricks for you to quickly parse a time string to the proper time format in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

You can use the below formula to convert the time string into the correct time format.

=TIME(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

Syntax Explanations:

TIME – The TIME Function in Excel helps to create time on your worksheet.
LEFT – In Excel, the LEFT function will extract digits from the numbers as well. It extracts the first character (starting from the left side) or characters from the given string based on the number you specified.
MID – This function is used to extract the number (starting from the left side) or characters from the given string. Read more on the MID function.
RIGHT – It helps to extract the characters from the right side of a text string. Read more on the RIGHT function.
A1 – It specifies the input date from your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

Here, we will enter the input dates in Column B.
Now we are going to find the proper time from the time string.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Conclusion:

From this guide, you can get some clarification on how to parse the time string into the original time format in Excel. If you have any questions or suggestions regarding this lesson, feel free to use the comments section below to let us know.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **