Hi Newbie here,

My excel knowledge is average.

I have 2 cells

I'm extracting data from a program i have.

Cell A1 Counts down to 00:00:00
Cell A2 has data that is refreshed every time its changes(min 1 sec)

I'm looking to capture the data from 00:05:00 down to 00:00:00 in a different sheet. I want to capture both cell contents.

Does anyone know how to do this with functions or do i need VBA???