Hi,

Here is my data and formula
A B C
0:10:00 0:32:00 =if(b1=a1:a3,Break,N/A)
0:11:00 0:10:00
0:12:00 1:07:00

but the data from B column is formulas and not a typed value.

any suggestions


--
sydolly
------------------------------------------------------------------------
sydolly's Profile: http://www.excelforum.com/member.php...o&userid=27128
View this thread: http://www.excelforum.com/showthread...hreadid=466425