I need help figuring out how I can take a value from a cell at a specific time and then put that in another cell. Then if the orginal cell changes value it does not change the cell that is in another location.
like short of:
C2=if(now()=""08:29")"H2",""
But in the formula above if the time does not equal 08:29 then a blank cell is going to be in C2. I want the value of H2 at 8:29 to stay in C2.
So the next part is that at 8:30 the value of H2 is going to change but I still want the 8:29 H2 to be in the cell C2.
If anyone has any ideas please help. Thank you
like short of:
C2=if(now()=""08:29")"H2",""
But in the formula above if the time does not equal 08:29 then a blank cell is going to be in C2. I want the value of H2 at 8:29 to stay in C2.
So the next part is that at 8:30 the value of H2 is going to change but I still want the 8:29 H2 to be in the cell C2.
If anyone has any ideas please help. Thank you
