I have a spreadsheet where I have 5 columns that only times are supposed to
be entered. Is there a way that I can keep people from entering anything
other than times - ex. "none", "n/a", "xx", etc. Numerous people enter data
on this sheet and I have told the many times not to enter anything except a
time, if they don't have a time to leave it blank but it doesn't help.

I already have one validation in there.

Thanks for any help.

Check out data validation and select time between 00:00 and 23:59

"Denise" wrote:

I have a spreadsheet where I have 5 columns that only times are supposed to
be entered. Is there a way that I can keep people from entering anything
other than times - ex. "none", "n/a", "xx", etc. Numerous people enter data
on this sheet and I have told the many times not to enter anything except a
time, if they don't have a time to leave it blank but it doesn't help.

I already have one validation in there.

Thanks for any help.

I already have used validation. Can I set up two validations?

"Denise" wrote:

I have a spreadsheet where I have 5 columns that only times are supposed to
be entered. Is there a way that I can keep people from entering anything
other than times - ex. "none", "n/a", "xx", etc. Numerous people enter data
on this sheet and I have told the many times not to enter anything except a
time, if they don't have a time to leave it blank but it doesn't help.

I already have one validation in there.

Thanks for any help.