On Tuesday, April 24, 2018 at 1:41:39 AM UTC-5, wrote:
On Tuesday, September 29, 2009 at 3:02:01 PM UTC+5:30, goneil wrote:
I want to time stamp a cell automatically with the current time (ie) without
the data entry operator having to do anything, however I don't want it to
update all the time I want it to just remain as is permenantly. I cannot
make NOW() stay the same.
Cheers

I have a similar query. I want to generate a timestamp in Column C whenever someone enters any complaint in Column B.
So I have used this formula in all the cells of Column C
"=IF(B3="","",TEXT(NOW(),"dd/mm/yy/hh:mm"))"

But the problem is that the timestamp keep getting updated. I want to lock it down to the initial timestamp.
Can you suggest any code for this?
Thanks

--

<https://www.somaiya.eduÂ* Â* Â* Â* <http://www.somaiya-ayurvihar.orgÂ*
<http://nareshwadi.orgÂ* <http://somaiya.comÂ* <http://www.helpachild.inÂ*
<http://nareshwadi.org

Has anyone come up for a solution to this one? I would also like to do the same. I would like to enter a callers name into column C, then have the NOW time populate into column B. currently this works but it will update. I would like to know how to eliminate the updating.