| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text in cell to hh:mm:ss
Hi,
the easy way: select the cell and choose Data, Text to Columns, Delimited, Next, check Space, Next, in the preview pane select days column and then click do not import skip, repeat this for the hrs, min, and sec column, pick a destination cell and click Finish. Suppose the destination cell was B1, in A2 enter =B1*1440+C1*60+D1+E1/60 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "dgarza" wrote: One of the columns in my spreadsheet has a text field displaying 1 days 1 hrs 30 min 18 sec and I would like to convert this to total minutes. Thank you David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert a text cell into date cell in Excel | Excel Discussion (Misc queries) | |||
| How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
| convert number in cell to text in another cell | Excel Worksheet Functions | |||
| HOW CAN I CONVERT NUMBER IN A CELL TO TEXT EG: 100 TO ONE HUNDRED | Excel Worksheet Functions | |||
| HOW CAN I CONVERT NUMBERS INTO TEXT IN A PARTICULAR CELL. | Excel Discussion (Misc queries) | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
