Time and Date Formula
 

I would like help on a bit of a problem i have for time keeping. I have a
sheet where i can keep track of my equipment, when ever an employee checks
out the equipmnet, it give me the time and date when they did...but every
time a new employee check out anoter set...all the cells automatically
update....Is there a way i can stop that change...This is what im using

=IF(A1,NOW(),1)
Next Cell:
=IF(A2,NOW(),1)...and so on...

is there another formula i can use...or is there a way to stop the other
cells from changing..

Thanks for any help I can get on this subject
LJ

Time and Date Formula
 

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
(You can't use formulas as the "date/time stamps" as these will recalc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"LJ" wrote:
I would like help on a bit of a problem i have for time keeping. I have a
sheet where i can keep track of my equipment, when ever an employee checks
out the equipmnet, it give me the time and date when they did...but every
time a new employee check out anoter set...all the cells automatically
update....Is there a way i can stop that change...This is what im using

=IF(A1,NOW(),1)
Next Cell:
=IF(A2,NOW(),1)...and so on...

is there another formula i can use...or is there a way to stop the other
cells from changing..

Thanks for any help I can get on this subject
LJ

Time and Date Formula
 

MANYThank Yous Max, just what i needed.

"Max" wrote:

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
Scroll down to the part: Using a worksheet event macro
(You can't use formulas as the "date/time stamps" as these will recalc)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"LJ" wrote:
I would like help on a bit of a problem i have for time keeping. I have a
sheet where i can keep track of my equipment, when ever an employee checks
out the equipmnet, it give me the time and date when they did...but every
time a new employee check out anoter set...all the cells automatically
update....Is there a way i can stop that change...This is what im using

=IF(A1,NOW(),1)
Next Cell:
=IF(A2,NOW(),1)...and so on...

is there another formula i can use...or is there a way to stop the other
cells from changing..

Thanks for any help I can get on this subject
LJ

Time and Date Formula
 

Welcome. But do take a moment to press the "Yes" button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"LJ" wrote:
MANY Thank Yous Max, just what i needed.