| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date & time assistance
I have in cell A1 19/04/05 23:10. in dd/mm/yy hh:mm format.
To convert only to date I have entered in B1 I have entered =a1*1 In C1 I have entered =b1 and formnatted to date. Any idea how I can extract just the time. The end result i am after is to seperate out the date & time to 2 seperate cells. Apologies if am convuluted but am new!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Help - Information with time and date | 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) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Threaded Mode
