G
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.
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.