How to read the last updated data

excel

#1

Hi Everyone

I have a doubt, For example i have to Run a cycle in some data processing tool, after every run, the tool will update the start time and Finish time down side to the last run data.
Now i want to read the latest Finish time and write into an excel sheet. Can anyone help me in this. Below is the Example.

Started:
Start time:12:00:00PM
Finish time: 12:15:00PM

Started:
Start time:01:00:00PM
Finish time: 01:15:00PM

Started:
Start time:03:00:00PM
Finish time: 03:15:00PM
.
.
.
.
.
.
.
.
.
.
Same as above data

From the above example every time i want to read the last run finish time.


#2

string.match(/Finish time(?!.*Finish time)/)[0] and extract the text using index and check if it works


@harsha1123