| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text to time convert
How can I convert text to time format in cell.
i.e text in cell A1 is 163233 - 16 is hour, 32 is min and 33 is sec. I need convert this text to time format: 16:32:33 Thanks for help, Rudo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert DATE and TIME to text | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
