I have a spread sheet that 8 different people access. There are times that
are entered - Arrival Time, Triage Time, To ED Time, Saw MD Time and
Discharge Time. I have formulas to calculated the wait times.

There are lots of problems with people entering the times wrong from the
chart - whether it is a typo or the incorrect time is written on the patient
chart. I need to put something in the worksheet that will not let the person
enter the time if it is wrong.

Example - the person will arrive at 900 and be placed in a room at 830.
This is not possible since they are not even here.

Can anyone help me with this?

Thanks.