Excel Formulas to Convert the Text Timestamps into Time ~ Easy Ways!!
Tags: excelformula, excelformulas
Published: 2021-05-07 12:31:32

---
title: Excel Formulas to Convert the Text Timestamps into Time ~ Easy Ways!!
published: true
date: 2021-05-07 06:39:50 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-convert-the-text-timestamp-into-time/
---

For instance, you have a list of text strings 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 **convert text timestamps into time in Excel**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Convert text timestamps into time](https://geekexcel.com/wp-content/uploads/2021/05/Convert-text-timestamps-into-time.png)](https://geekexcel.com/excel-formulas-to-convert-the-text-timestamp-into-time/convert-text-timestamps-into-time/#main)<figcaption id="caption-attachment-36951">Convert text timestamps into time</figcaption>

## Generic Formula:

- If you want to change the text timestamp into the original time format in Excel, you can use the below formula.

**=[TIME](https://geekexcel.com/how-to-use-time-function-in-excel-365/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(A1,1,2),MID(A1,4,2),MID(A1,7,2))**

## Syntax Explanations:

- **TIME** – It helps create time on your worksheet. You can specify the **[hour](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/), [minutes](https://geekexcel.com/how-to-use-minute-function-in-excel-365/), [seconds](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/)** value inside the **[TIME function](https://geekexcel.com/how-to-use-time-function-in-excel-365/)**.
- **MID** – In Excel, the **[MID function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)** will extract the number (starting from the left side) or characters from the given string.
- **A1** – It represents the input time from your worksheet.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.

## Practical Example:

Let’s consider the below example image.

- Here we have the input text timestamp in **Column B**.
- Now we are going to convert them into the original time format.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-6.png)<figcaption id="caption-attachment-36953">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-18.png)<figcaption id="caption-attachment-36952">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-18.png)<figcaption id="caption-attachment-36954">Result</figcaption>

## Bottom-Line:

In this lesson, we looked at how the TIME function can be used to **convert text timestamps into a time value 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 our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Convert Text into Date Format ~ A Complete Tutorial!!](https://geekexcel.com/excel-formulas-to-convert-text-into-date-format/)**
- **[Excel Formulas to Convert Date-time to Time Zone ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-convert-date-time-to-time-zone/)**