Thanks, but I ended up doing the following:

Log-In list is in column A (e.g A2:A8), organize your sheet as follows:


Cell C1: "Hour"; Cell D1: 7/1/2005; Cell E1: 7/2/2005; ...; Cell AH:
7/31/2005

Cell C2: "0:00"; Cell C3: "1:00"; ...; Cell C25: "23:00": format C2:C25
as "h:mm"

Cell D2:
"=SUMPRODUCT(--(DAY($A$2:$A$8)=DAY(D$1)),--(TIME(HOUR($A$2:$A$8),MINUTE($A$2:$A$8),0)=$C2),--(TIME(HOUR($A$2:$A$8),MINUTE($A$2:$A$8),0)<=TIME(H OUR($C2),59,59)))"


Copy Cell D2 - Paste Range D2:AH25

select Range D2:AH25 (with Cell D2 active cell) and click Format-
Conditional Format: Select "Formula Is" and enter the following
formula:
"=(D2=MAX(D$2:D$25))"

It worked great.
Thanks for your reply, though


--
Eagle784
------------------------------------------------------------------------
Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261
View this thread: http://www.excelforum.com/showthread...hreadid=396973