| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formulas to pull date and time from 1 cell to 2
I have a report with date and time column. The data looks like this:
11/6/2008 2:18:00 PM I need to pull the date into one cell and the time into another. How can I do this when the date and time will vary in the number of characters? i.e =left(a1,9) will miss part of the date if were another character long, like 11/16/2006. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you just pull Just the Time Value out of a Cell? | Excel Discussion (Misc queries) | |||
| Pull and store a value on specific date in another cell | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Threaded Mode
