Convert time to text in Excel and Google Sheets

=TEXT(A2,"hh:mm:ss AM/PM")

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert time to text in Excel

How to convert time to text in Excel?
Convert time to text in Excel

CONVERT TIME TO TEXT — EXCEL FORMULA AND EXAMPLE

=TEXT(A3,"hh:mm:ss AM/PM")

The result in column C will be stored as a text

💡 Detailed time format explained here

Convert time to text in Google Sheets

How to convert time to text in Google Sheets?
Convert time to text in Google Sheets

CONVERT TIME TO TEXT — GOOGLE SHEETS FORMULA AND EXAMPLE

=TEXT(A3,"hh:mm:ss AM/PM")

The result in column C will be stored as a text

💡 Detailed time format explained here