Hi,

I need to check rows of data which hold the tasks performed at
different times throughout a working day. I want to extract the start
and end times of the meal breaks within each row. I can do this by
checking the value of each cell and taking the header value (the time)
of the column which contains the start of the break, but how do i then
continue to check the remaining part of the working day to find the
end of break time and importantly, the start and end of any other meal
breaks within the same row?

I would want to paste the time values found into the same row, at the
end of the dataset.
A point to note, duties can have none, one or two meal breaks.

Hope you can help?

Kind regards,
Matt