|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
07-18-2014, 09:55 PM
|
||||
|
||||
You can extract the dates & times with a formaula like:
=--SUBSTITUTE(SUBSTITUTE(TRIM(MID(A1,FIND("/",A1)-1-(FIND("/",A1)>2),LEN(A1))),"AM"," AM"),"PM"," PM") where the string you're processing is in A1. This returns a number which you can format as a date & time if you prefer. As for the comparisons, are the data sorted by date & time? If so, the comparison requires nothing more than a simple subtraction using the results of the above formula.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| date cell formatting, extract, formula |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Parse date and time from one cell and paste it to another for all files in a folder?
|
chrisd2000 | Excel Programming | 3 | 07-03-2014 10:56 AM |
| 2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
| How to format cell in order to display *both* time and date | SamyCode | Excel | 3 | 01-22-2013 03:30 PM |
|
Extracting text from a Word Doc into Excel
|
dgcarlin | Word VBA | 1 | 07-06-2012 05:46 PM |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode