J
JVS
Question: I am looking for a way to flag a user when they enter a "text"
value in a cell.
I have a formula in cell F11, this is close but I had to hard code the cell
"ID" as part of the error message and it does not update automatically when
the formula is copied to the next row
Formula from F11:=IF(COUNTA(C11)=1,"Delete C11",IF(COUNTA(D11)=1,"Delete
D11",IF(COUNTA(E11)=1,"Delete E11",IF(D11+E11>0,(D11-C11)+E11,"0:00"))))
"Is there an easy to capture the cell ID if that cell contains a text value?
I tried using data validation rules for "time" but it limits the range from
0:00 to 23:59 and I have a lot of associates that work later than that work
till 2:00 to 4:00 am and they are use to enter their time as 8:00 to 26:00
or 28:00 which properly calculates their time."
My problem is that the users enter "space bar" or 8;00 vs. a valid time
value, this results in a #value error message and call for help.
Any suggestions are greatly appreciated.
Thanks!
Johnny
value in a cell.
I have a formula in cell F11, this is close but I had to hard code the cell
"ID" as part of the error message and it does not update automatically when
the formula is copied to the next row
Formula from F11:=IF(COUNTA(C11)=1,"Delete C11",IF(COUNTA(D11)=1,"Delete
D11",IF(COUNTA(E11)=1,"Delete E11",IF(D11+E11>0,(D11-C11)+E11,"0:00"))))
"Is there an easy to capture the cell ID if that cell contains a text value?
I tried using data validation rules for "time" but it limits the range from
0:00 to 23:59 and I have a lot of associates that work later than that work
till 2:00 to 4:00 am and they are use to enter their time as 8:00 to 26:00
or 28:00 which properly calculates their time."
My problem is that the users enter "space bar" or 8;00 vs. a valid time
value, this results in a #value error message and call for help.
Any suggestions are greatly appreciated.
Thanks!
Johnny