Working with times
In this set up you can add a formula in cell D3 as follows:
=IF(B3="","",IF(B3<C2,"ERROR",""))
and copy it into D4 (and downwards). I have assumed you have a row of
headings, so you actually want to check from the second entry onwards.
Hope this helps.
Pete
|