Thank you! That's what I am looking for. Now I have to try to understand
it [o: hehe. Thank you again!
Bob Phillips Wrote:
One more shot
=IF(AND($D3G$2,$D3<G$2+1/24,$F3G$2),"-X",
IF(AND($D3<G$2,$F3G$2,$F3<G$2+1/24),"X-",
IF(AND($D3<=G$2,$F3=G$2),"XX","--")))
--
magecca
------------------------------------------------------------------------
magecca's Profile:
http://www.excelforum.com/member.php...o&userid=29250
View this thread:
http://www.excelforum.com/showthread...hreadid=489734