On Sat, 5 Feb 2005 19:25:02 -0800, Mike R
wrote:

xl 2000--I am tracking transaction times and would like to use CF to highlite
times more than and less than 2 minutes. I tried to use "cell value" and it
is not recognizing :02, (for instance). What would a formula be that would
work to do this? I think I need to convert the answer to a portion of a day?
I am using a formula to subtract the start time and the end time. The results
are formated as time ie :01, :06, :11, :02 etc.

Depending on what you want to do at exactly two minutes:

Cell Value is Less Than 0.0013888888888889


--ron