|After re-reading your post several times, |
do you want a formula that will give a warning
if any time prior to 7:00 AM is entered and
if any time after 10:00 PM is entered?
If so, then try this formula:
This will first check cell C4 to make sure the time entered is 7:00 AM or later
then it will check cell D4 to make sure the time entered is 10:00 PM or earlier.
Is that what your looking for?
message edited by mmcconaghy