View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LJ LJ is offline
external usenet poster
 
Posts: 16
Default 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