IF Formula if Time is Greater than 10am


Here is my issue.

In column “F3” I have a import time in the format 09:00. In column “T3” I’m trying to create a formula that shows that if the time in F3 is greater than 10:00 it displayes the text “After”, and if it’s less that 10:00 the text displays “Prior”. I’ve tried the following, which gives me a “0” to replace the error =IF(F3=”<10:00″,”Prior”,IF(F3=”>10:00″,”After”,”0″))

Please can you let me know where I’m going wrong.

Thank you for your help.



By: Craig

944 thoughts on “IF Formula if Time is Greater than 10am

  1. 신분증위조

    This is very interesting, You are a very skilled blogger. I ave joined your feed and look forward to seeking more of your wonderful post. Also, I have shared your web site in my social networks!

  2. borneo kratom

    wonderful submit, very informative. I ponder why the opposite experts of this sector don’t realize this.
    You must proceed your writing. I am sure, you have
    a huge readers’ base already!

  3. kratom

    Hey there, I think your site might be having browser compatibility issues.
    When I look at your blog site in Ie, it looks fine but when opening in Internet Explorer, it has some overlapping.
    I just wanted to give you a quick heads up! Other then that,
    great blog!

  4. Chang Beatie

    I loved as much as you’ll receive carried out right here. The sketch is tasteful, your authored material stylish. nonetheless, you command get got an impatience over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly a lot often inside case you shield this hike.

Comments are closed.