Scarlett1

You might want to use the hour function to extract the hour of the
start time and/or finish times depending upon your requirements.

Then check if this start time is before or after 6 pm (you might again
want to extract the hour of the 6pm) before you perform this check.


Best regards


Deepak Agarwal


--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345
View this thread: http://www.excelforum.com/showthread...hreadid=384375