Hi Guys,
Is it possible to make a macro that extracts a specific date and time from a text string and calculate the difference between a start date and time. Then it proceeds to loop through the string and locate the next specific date and time occurence and extract first found occurence from this one? see the data below
Screenshot 2020-02-19 at 14.56.44.png
So i have the column A and B where A is my starting point and B reports a list of incidents. I would like to find the time between my starting point and the first incident and then print that difference in column C. Followed by the time between incident 1 and incident 2 in column D and so forth for as many incidents as there might be. The incident report might contain random text and have different shapes but the date/time format is always the same. There is however the issue that there might be other notes in the incident report that also have a time stamp..... Like the random note in the picture. These are not to be considered. Incidents are only uniqe by their incident stamp in the end of the text string. The difference between incidents is calculated in minutes. Help would be very much appreciated, since im quite lost on how to do it
Cross-post link https://www.mrexcel.com/board/thread.../#post-5430133
Bookmarks