View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Time Stamp formula

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
"Murph" wrote:

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.