return a snapshot of a cell value at a designated time

I am rusty but what I want to do is return a snapshot of a cell value at a designated time (it will be saved in an array) so it either returns the cell value at the designated time else 0.

In words: if time now is 9.50.00 am return value in cell A1 else 0

thought I had it with =IF(TIME(9,50,00),A1,0) which just returns 00:00:00 regardless of time designated or not

I have also tried referencing the cell containing =NOW()

I am not sure if TIME is actually the function I need - tried various ways of incorporating =NOW() but it either is not able to be incorporated into a formula or I am nesting it incorrectly.

As I said I am rusty - if someone knows how to do this please post - if you know it it can't be done e.g. functions are not right for this, or you know there is no way Excel can do this, please post.

If you need further clarifications please let me know. Basically. what I want to do is compare the value as it updates in real-time with what it was at a certain time (by referencing the cell reference in an array)

What I want to do is compare the value as it updates in real-time with what it was at a certain time (by referencing the cell reference in an array)

if ur given time is equal to current time then it will show in A1 cell else 0

then use this formula :
=IF(TEXT(TIME(15,48,0),"hh:mm")=TEXT(NOW(),"hh:mm"),NOW(),0)

if u want sec. also then
=IF(TEXT(TIME(15,48,0),"hh:mm:ss")=TEXT(NOW(),"hh:mm:ss"),NOW(),0)


also that A1 cell number formatting will be Time formatting