This should be an easy one for you gurus...

I a cell, I have a NOW() function that keeps updating everytime a value
changes.

=IF(F22 = "","",NOW())

Isn't there a way to capture the date/time and "lock it" so that it doesn't
change? I'm keeping track of user input date & time values.

tia,
--
JMorrell

Take a look he

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


In article ,
"JMorrell" wrote:

This should be an easy one for you gurus...

I a cell, I have a NOW() function that keeps updating everytime a value
changes.

=IF(F22 = "","",NOW())

Isn't there a way to capture the date/time and "lock it" so that it doesn't
change? I'm keeping track of user input date & time values.

Yep. That's what I was looking for. Thank you!

JMorrell



"JE McGimpsey" wrote:

Take a look he

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


In article ,
"JMorrell" wrote:

This should be an easy one for you gurus...

I a cell, I have a NOW() function that keeps updating everytime a value
changes.

=IF(F22 = "","",NOW())

Isn't there a way to capture the date/time and "lock it" so that it doesn't
change? I'm keeping track of user input date & time values.