| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying part of a cell's contents (formatted as dd:hh:mm)
Is there a way to extract (copy) a particular portion of a cell's contents
where the cell's number format is dd:hh:mm? For instance, 04:09:12 indicates 4 days, 9 hours and 12 minutes. I would like to extract the days, hours, and minutes separately and copy them to three separate cells. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Swap contents of two cells | Excel Discussion (Misc queries) | |||
| Clearing the Contents of Merged Cells | New Users to Excel | |||
| Problems copying cells using offset and counta | Excel Discussion (Misc queries) | |||
Threaded Mode
