Current Time
=IF(A10,NOW(),0)
that will put the current time if a value of 0 is entered
it will be a funny number, if you format the cell Time it will be a time
"ub" wrote:
Hi
What I want to do is that if I enter a value in a cell (Ex A1), in cell A2,
I want the current system time to automatically stamp and save it.
Please advise if this is possible.
Thanks
|