Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Validation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Validation
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TIME VALIDATION | Excel Discussion (Misc queries) | |||
validation of time | Excel Worksheet Functions | |||
Time in data validation? | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |