Hello Ben,
You need a nested IF statement in column C:
=IF(B1A1,"Late",IF(B1=A1,"On-Time","Early"))
If you need any further help with this formula post back.
Judith
--
JudithJubilee
------------------------------------------------------------------------
JudithJubilee's Profile:
http://www.excelforum.com/member.php...fo&userid=6882
View this thread:
http://www.excelforum.com/showthread...hreadid=519163