| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Add colon to times
Is there a way to add a colon (:) to times?
Example: At the moment I have A1 (hours) 2 B1 (minutes) 4 C1 (seconds) 8.321 I want these to end up in a single time cell as 2:4:8.321 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas need semi-colon, how to change to comma | Excel Discussion (Misc queries) | |||
| Is there a way to enter times without typing a colon? | Excel Discussion (Misc queries) | |||
| Insert colon in text in cell | Excel Discussion (Misc queries) | |||
| Format cell to show colon | Excel Worksheet Functions | |||
| Replace nth place with colon | Excel Worksheet Functions | |||
Threaded Mode
