Thanks that works. But why is it when both cells are in HH:MM format
and you subtract the two they create this number like
0.00283533333333333? That is just a PITA and now you have to go back
and reinvent the wheel with your conditional formatting. Is there
anyway around this?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=564803