I have a very large spreadsheet that numerous people enter data in. I have a
validation for time to prevent them from entering a wrong time (triage time
before they arrive, etc.) This works fine except when they arrive before
midnight and are discharged after midnight.

The validation that I have is CUSTOM and the formula I have is =J2=I2.

ARRIVAL TRIAGE
0:21 0:25
0:54 0:58
23:40 0:05
23:50 23:45 THIS IS THE ERROR THAT I AM TRYING TO
AVOID

Thanks for your help.