I have a scheduling template that we use at work. It needs to allow
allow all types of data entry EXCEPT dates and times. Any numbers
entered must be in a format that I can use in formulas.

In other words, I need to have entries that can be numbers or text but
NOT times.
Thus I need the cells formatted as General. General formatting makes
10:00 show up as 0.416667. I need data entries to be restricted to
non-
times. Can I have data validation set up to restrict time entries only
but still be able to enter numbers that can be used in formulas?

I have tried to flag with data validation using Right(A1,3)=":" but
that doesn't seem to work. Any ideas?? Thanks