I have a list of employees whose start and end time are contained in the
same cell, in the same column. The format looks like this: 11:00-21:30,
but with varying start and end times. I need to keep that format for
internal purposes. I need a formula that will count the number of
employees starting before a specified time, say 11:00 for example.


--
monger
------------------------------------------------------------------------
monger's Profile: http://www.excelforum.com/member.php...o&userid=17911
View this thread: http://www.excelforum.com/showthread...hreadid=511258