I had a project in excel in which I wanted a macro to capture the current
time and paste it into a cell as an absolute value of that time instance,
whilst the time continued to tick forward, and thus being able to once again
capture a fresher record of the time at a later date by doing the same.

Previously I had used the =now() [in cell A1] and formatted the cell for the
time only and pasted the "value" to another cell [cell B1]. What i found was
that the =now() function was not aiding the advancement of the time in REAL
time and only updated it upon pressing the dlete key in an unused cell.
I gues what I might need is a REAL TIME clock that continues to tick the
seconds whilst the sheet is open. Can that be done or is there an easier way.

Thanks