• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Current time in a cell should not change

A

Ashish Batham

Member
I am using the below mentioned formula to show current time in a cell

=IF(C3<>"",IF(B3="",NOW(),B3),"")

however this time keep on changing to the current time when the spreadsheet is refreshed.
Please advice, if once the cell captures the current time this should not change when the spreadsheet is refreshed

Thanks & Regards
 
Hi Ashish ,

First , this is an example of circular referencing ; this formula should be entered in cell B3 , and it refers to B3.

For this to work , you should enable iterative calculation , and use as many iterations as you think fit.

Once the above are done , the time in B3 will never change , unless you clear the contents of cell C3 , and then re-enter some data in it.

Narayan
 
Hi Narayan,

Thanks for the above details.

I have enabled the iterative calculation, however if I enter details in other cells or referesh the spreadsheet the time again changes

Please advice,
Regards,
Ashish
 
Hi Ashish ,

Not on my computer.

I have entered the following formula in cell B3 :

=IF(C3<>"",IF(B3="",NOW(),B3),"")

As long as C3 is blank , B3 is also blank.

When ever C3 is populated with some data , immediately B3 gets the current time.

Thereafter , what ever is done in the rest of the worksheet , the time in B3 never changes.

Narayan
 
You must log in or register to reply here.
Back
Top