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.
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.
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.
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
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!)
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.
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!|
|Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.|
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 8 days agoThese formulas are super helpful, thank you. I find that I have a question about your Convert Time To Text String formula.I am using it to retain the hh:mm formatting in Excel into a Word doc via a mail merge.
To post as a guest, your comment is unpublished.· 3 months agoHiunable to get the formula in the excel
To post as a guest, your comment is unpublished.· 9 months agoreally helpful, thx!
To post as a guest, your comment is unpublished.· 2 years agoPerfect. Thank you!!