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.

Time Stamp formula
 

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



--
Regards,

Peo Sjoblom


"Murph" wrote in message
...
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.

Time Stamp formula
 

On May 2, 6:11 pm, 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.

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

HTH
Kostis Vezerides

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.

Time Stamp formula
 

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

"vezerid" wrote:

On May 2, 6:11 pm, 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.

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

HTH
Kostis Vezerides

Time Stamp formula
 

On May 2, 8:58 pm, Murph wrote:
fairly certain that there's a parantheses missing somewhere in that....

"vezerid" wrote:
On May 2, 6:11 pm, 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.

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

HTH
Kostis Vezerides


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

Regards,
Kostis