Time Validation

[Guest]

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.

 

[Roger Govier]

Hi Denise

Maybe
=(J2-I2)>0