+ Reply to Thread
Results 1 to 2 of 2

New to excel,please help

  1. #1
    Ben
    Guest

    New to excel,please help

    Hi,

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

    A B C
    Expected actual answer
    08:00 08:00 Early
    On-time
    late
    If the times match in A & 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


  2. #2
    Registered User
    Join Date
    03-07-2004
    Posts
    6
    Hello Ben,

    You need a nested IF statement in column C:

    =IF(B1>A1,"Late",IF(B1=A1,"On-Time","Early"))

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

    Judith

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1