| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Time PDT
I have inherited an excel spreadsheet that has a column with both the date
and time in it followed by the abbreviation PDT ( pacific daylight time). I would like to use a formula to change the column A entry to two columns .....date and time. Any help will be greatly appreciated. Ex; column A B C 6/4/2008 21:00 PDT change to 6/4/2008 21:00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating days & time left from start date/time to end date/time | 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) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Threaded Mode
