Automatically insert time without changing.

[Joker]

I am trying to find a formula which will automatically insert the current
time into a cell based on if there is info in another cell. In cell B48, I
have the formula =IF(C48>0,NOW(),""). The formula works and
displays the time, however, it keeps changing as I make other changes on the
worksheet. Is there anyway to keep it from changing times? Thanks for your
help.

 

[Dave Peterson]

You can use a macro...

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

If you want to read more about these kinds of events:

Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm