| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combined date time cell to separate date & time components
From file dump have combined date time cells eg 14/04/03 14:20 (value
37725.59722). Want to perform time analysis so need to split to 2 separate cells; eg. "14/04/2003" (value 37725) & "14:20" (value 0.59722). Is there a fnc to do this? (Currently convert cell to value, then fncs trunc & cell less int(cell) then refmt to date dd/mm/yy & time hh:mm respectively) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| Split combined date time data | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
| Date and Time Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
