Posted to microsoft.public.excel.worksheet.functions

Murph

external usenet poster

Posts: 37

Time Stamp formula

I am trying to place a time stamp in cell L2 if there is text inside of cells
F2:J2. This seems like it should be an easy thing to do but I can't wrap my
brain around it this morning.

The formula I have so far is simply:
=IF(F20,NOW(), )

This gives me a time stamp for only cell F2, but I need the formula to watch
from F2-J2. Thanks in advance.

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
Time Stamp	japc90	Excel Discussion (Misc queries)	7	August 22nd 06 04:19 PM
How do I lock a stamp date/time formula for an entry on a row?	PROPERTIES INC.	Excel Worksheet Functions	3	August 4th 06 12:45 AM
Time Stamp	sunderland27	Excel Discussion (Misc queries)	3	April 19th 06 07:05 PM
time stamp	jiwolf	Excel Worksheet Functions	4	December 20th 05 07:18 PM
Time Stamp	Richard	Excel Discussion (Misc queries)	4	February 2nd 05 11:16 PM

All times are GMT +1. The time now is 09:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us