You can use the following formula to convert time to text in Excel:
=TEXT(A2,"h:mm AM/PM")
This particular formula converts the time in cell A2 to text.
The following example shows how to use this formula in practice.
Example: Convert Time to Text in Excel
Suppose we have the following column of times in Excel:
Currently each of these times is not stored as text.
We can verify this by typing the following formula into cell B2:
=ISTEXT(A2)
This formula returns FALSE, which tells us that the time value in cell A2 is not currently recognized as text.
Suppose we would like to convert each time in column A into text.
We can type the following formula into cell B2 to do so:
=TEXT(A2,"h:mm AM/PM")
We can then click and drag this formula down to each remaining cell in column B:
Each cell in column B now contains the corresponding time in column A formatted as text.
We can verify that each cell in column B is text by typing the following formula into cell C2:
=ISTEXT(B2)
We can then click and drag this formula down to each remaining cell in column C:
The formula returns TRUE for each row, which indicates that each time value in column B is stored as text.
Note: You can find the complete documentation for the TEXT function in Excel here.
Additional Resources
The following tutorials explain how to perform other common operations in Excel:
Excel: Calculate Difference Between Two Times in Hours
Excel: Calculate Difference Between Two Times in Minutes
Excel: How to Calculate Average Time
