Why not just use the ROUND function on the two times in your conditional
formatting formula, to force them to the same number of decimal places? From
your example data, they are identical out to 10 decimal places. Do you need
more precision than that?

Hope this helps,

Hutch

"changetires" wrote:


when comparing two different times why is 00:30 minutes giving me a
number like .02083333333333333333 and 0:30 minutes from a vlookup table
is giving me a number like .0208333333284827

whats up with that that is why my conditional formatting is a problem

ed


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