ExcelBanter - Time Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Validation (https://www.excelbanter.com/excel-discussion-misc-queries/142654-time-validation.html)

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.

Hi Denise

Maybe
=(J2-I2)0

--
Regards

Roger Govier

"Denise" wrote in message
...
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.