| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dates and times with PST,PDT
I have data in the form of dates and times that need to be sorted. I want to convert the data to general format. My problem is that I have PST (Pacific Standard Time) and PDT (Pacific Daylight Time) included in the cells. How can I get Excel to ignore the PST and PDT abbreviations in each cell and convert my data to the general format?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Dates and times again | Excel Worksheet Functions | |||
| merge dates and times into one column? | Excel Discussion (Misc queries) | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
| Times and Dates | Excel Discussion (Misc queries) | |||
Threaded Mode
