Automatically insert time without changing.

Posted to microsoft.public.excel.misc

Joker

Posts: n/a

Automatically insert time without changing.

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(C480,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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert a picture that automatically sizes to size of cell?	ursa_nz	Excel Worksheet Functions	0	August 22nd 05 02:56 AM
How do I automaticly insert the time with seconds	AussieAVguy	Excel Discussion (Misc queries)	2	June 14th 05 05:12 PM
How do I stop excel automatically changing my date to 2005?	zoemcb	Excel Discussion (Misc queries)	6	April 30th 05 02:39 AM
Changing cell references automatically	Bigweed	New Users to Excel	3	April 28th 05 12:27 PM
how do i insert the current time into a cell, and show different .	Dave	Excel Discussion (Misc queries)	1	March 22nd 05 06:57 PM

All times are GMT +1. The time now is 09:30 AM.

Menu

About Us