Time Stamp formula

[Guest]

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(F2>0,NOW(), )

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

 

[Peo Sjoblom]

Regardless it will not give a time stamp when something was entered if
that's what you want, it will change with the computer's clock so when you
open it tomorrow it will have the date of tomorrow

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

has examples of real time stamps

 

[vezerid]

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(F2>0,NOW(), )

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

=IF(OR(F2:J2<>"",NOW(),"")

HTH
Kostis Vezerides

 

[Guest]

If use VBA try this
Paste into the sheet Module
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("F2:J2")) Is Nothing Then
With Target
If .Value <> "" Then
Range("A1").Value = Format(Now(), "hh:mm:ss AM/PM")
End If
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub

 

[Guest]

fairly certain that there's a parantheses missing somewhere in that....

 

[vezerid]

fairly certain that there's a parantheses missing somewhere in that....

Yep, you are right:
=IF(OR(F2:J2<>""),NOW(),"")

Regards,
Kostis