close

Hi,

I really need help with building a formula to do the following:

ABC
Expectedactualanswer
08:0008:00Early
On-time
late
If the times match in A amp; B then c would equal ON-TIME if B is before A,
then c would equal EARLY,if B is later than A,then C would Equal LATE

Thanks
Hello Ben,

You need a nested IF statement in column C:

=IF(B1gt;A1,quot;Latequot;,IF(B1=A1,quot;On-Timequot;,quot;Earlyquot;))

If you need any further help with this formula post back.

Judith--
JudithJubilee
------------------------------------------------------------------------
JudithJubilee's Profile: www.excelforum.com/member.php...foamp;userid=6882
View this thread: www.excelforum.com/showthread...hreadid=519163

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄