How to quickly convert time to text or number of hours/minutes/seconds in Excel?

In this tutorial, I introduce the methods to convert time to text string or number string, or the number of decimal hours, minutes and seconds in Excel.

Convert time to text string

Convert time to number string

Convert time to number of hours/minutes/seconds

Convert time to text string

Here is a formula can convert time to text string.

Select the cell which will place the text result, type this formula =TEXT(A1,"hh:mm:ss AM/PM"), press Enter key. And if you need, drag fill handle down to apply this formula to the below cells.

doc time to text number 1
doc time to text number 2

Convert time to number string

To convert time to number string, you just need to format the time cells as General.

Select the time cells you want to convert, click Home tab, go to Number group, select General from the drop down list.
doc time to text number 3

Convert time to number of hours/minutes/seconds

If you want to convert time to number of hours/minutes/seconds, you can choose one of below methods to deal with.

Convert time to number of hours/minutes/seconds with formula

Time Formula Result
16:15:48      =A1*24 16.26
16:15:48 =A1*1440 975.8
16:15:48 =A1*86400      58548      

Remember to format the result cells as general.

Convert time to number of hours/minutes/seconds with Kutools for Excel

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

Select the cells you want to convert, click Kutools > Content > Convert Time > Time to Hours/Time to Minutes/Time to Seconds.
doc time to text number 4

Then the time will be converted.
doc time to text number 5

Tip: If you want to place the converted result in another place, you can click Kutools > Content > Convert Time > Convert Time to enable Convert Time dialog, choose a convert type, check Save to another location checkbox, and select a cell to place the result.
doc time to text number 6

Quickly and easily convert date to other date formatting in Excel

Have you ever tried to convert a date to day, month or year only? The formulas maybe hard to remember, but the Apply Date Formatting of Kutools for Excel can quickly convert a standard date to the date formatting as you need as below screenshot shown. Dont, waite, click for 30 days free trial!
doc apply date format
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Mike · 1 years ago
    Perfect. Thank you!!