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 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.
 |
 |
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.
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.
Then the time will be converted.
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.
Convert Time
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. |
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
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!
