Hi Guys,
Is it possible to make a macro that extracts the last occurence of a 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 second last date and time occurence and extract the last occurence from this one? see the data below
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 (the last occurence in the text string) 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. The difference between incidents is calculated in minutes. Help would be very much appreciated
Is it possible to make a macro that extracts the last occurence of a 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 second last date and time occurence and extract the last occurence from this one? see the data below
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 (the last occurence in the text string) 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. The difference between incidents is calculated in minutes. Help would be very much appreciated