Try this:

Column A: Name
Column B: Start Time
Column C: End Time
Column D, Row 1 8:00
Column D, Row 2 8:30

Column D, Row 3 =AND(D$1=$B3,D$2<=$C3)

Column D, Row 100: =Countif(D3:D99,"=TRUE")


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=537620