Convert Time to Text in Excel (3 Effective Methods)

In this article, we will show the ways to convert time to text in Excel with proper illustrations. The following image shows the input and output briefly.

Convert time to text in Excel


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Methods to Convert Time to Text in Excel

1. Use TEXT Function

The TEXT function converts a value to text in a specific number format. In this section, we will use a formula based on the TEXT function to convert time to text in Excel.

📌 Steps:

  • First, we add a new column on the right side.

  • Now, go to Cell C5.
  • Then put the following formula based on the TEXT function.

=TEXT(B5,"hh:mm:ss")

Apply TEXT function to convert time to text

  • Press the Enter button.

  • Finally, drag the Fill Handle icon downwards.

Drag the fill handle to fill the formula

Here, time is converted to text without changing the presentation.

Read More: Excel Convert Seconds to hh mm ss (7 Easy Ways)


2. Use a Suitable Text Editor

In this section, we will use a suitable text editor. We will copy the time to the editor, and then paste them into some text formatted cells.

Apply the following steps.

📌 Steps:

  • Go to the Desktop window.
  • Press the right button of the mouse.
  • Choose the Text Document option from New section on the appeared menu.

  • A new notepad window appears.

We will paste data into this notebook.

  • Go to the Excel Sheet.
  • Choose the Range B5:B9. Press the Ctrl + C to copy data.

Copy data to convert to text in Excel

  • Paste the data into the notepad by pressing Ctrl+V.

  • Now, change the format of the cells where to put the data.
  • Choose the Range C5:C9.
  • Press the down arrow from the Number format.
  • Choose the Text option from the list.

Change the format of cell to convert in Excel

  • Now, copy data from the notepad.

  • Then, paste data on Cell C5.

We can see time is converted to text with no change in data representation.

Read More: How to Convert Seconds to Hours Minutes Seconds in Excel


Similar Readings


3. Convert Time to Text Using Text to Columns Tool

In this section, we will apply the text to columns feature to convert time to text.

📌 Steps:

  • First, we copy the data from the Time column into the next column.

  • Choose Range C5:C9.
  • Select the Data tab.
  • Choose Text to Columns from the Data Tools group.

Apply text to columns feature to convert in text

  • The Convert Text to Columns Wizard window appears.
  • Choose the Delimited option.
  • Then, press the Next button.

  • 2nd window of the Convert Text to Columns Wizard feature.
  • Unmark all the options from the Delimiters, then press the Next button.

  • The last window appears finally.
  • Choose the Text option.
  • Click the Finish button.

Choose data type in Text to columns in Excel

  • Look at the sheet.

Converted data are in text format.

Read More: How to Convert Minutes to Hours and Minutes in Excel


Conclusion

In this article, we described how to convert time to text in excel with function and other features. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.


Related Articles

Alok Paul

Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo