J
jwood30349
Hello Everyone,
First of all, I am not a programmer so I desperately need help. My wife
runs a nonprofit organization that helps children and she wanted an
excel spreadsheet that allowed her employees to check a box when they
clock in and clock out and it would show a date time stamp.
The formula I'm using is: =If(B1="","",IF(C1="",NOW(),A1)).
This formula allows for an "x" to be put in a cell and a date time
stamp to be shown that reflects the time the "x" was put there. But,
what I want is to be able to put an "x" in a cell and the date and time
locks in that cell. The problem with this formula is that the date and
time changes if there are changes to the sheet.
What I need is a formula that will show the date and time that an "x"
was put in a cell that will not change after the "x" is put there, and
if possible will not allow the employee to remove the "x" once it is
put there. I appreciate any help I can get.
First of all, I am not a programmer so I desperately need help. My wife
runs a nonprofit organization that helps children and she wanted an
excel spreadsheet that allowed her employees to check a box when they
clock in and clock out and it would show a date time stamp.
The formula I'm using is: =If(B1="","",IF(C1="",NOW(),A1)).
This formula allows for an "x" to be put in a cell and a date time
stamp to be shown that reflects the time the "x" was put there. But,
what I want is to be able to put an "x" in a cell and the date and time
locks in that cell. The problem with this formula is that the date and
time changes if there are changes to the sheet.
What I need is a formula that will show the date and time that an "x"
was put in a cell that will not change after the "x" is put there, and
if possible will not allow the employee to remove the "x" once it is
put there. I appreciate any help I can get.