| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date & Time function
Hello everyone,
I need assistance with the formula, to also include time I have the date converting properly, just need the time as well, for example: Column A Converted 11022004 16:21 11/02/2004 Formula used TO CONVERT: =DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2)) Thanks for any help |
| 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 Discussion (Misc queries) | |||
Threaded Mode
