+ Reply to Thread
Results 1 to 5 of 5

IF statement on data validation, End time greater than Start time

  1. 06-02-2014, 12:26 AM #1
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    IF statement on data validation, End time greater than Start time

    Hi,

    Can anyone help me on how to create if statement on data validation to ensure user enter end time greater than start time if Same Date and Day.

    which validation criteria to be used?
    Reply With QuoteRegister To Reply
  2. 06-02-2014, 01:10 AM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: IF statement on data validation, End time greater than Start time 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 06-02-2014, 02:56 AM #3
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: IF statement on data validation, End time greater than Start time

    Hi ProtonLeah,

    What is the validation criteria top be selected? e.g. List, Decimal, Whole number, etc.

    And what is the data criteria to be selected? e.g. between, equal to, etc.

    Is possible you attach sample in workbook. I am not so clear the selected criteria. If the same date & day also need to be stated.
    Reply With QuoteRegister To Reply
  4. 06-02-2014, 04:17 AM #4
    Faridwahidi
    Faridwahidi is offline
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: IF statement on data validation, End time greater than Start time

    please refer to attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-02-2014, 08:04 AM #5
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: IF statement on data validation, End time greater than Start time

    Pl see attached file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to calculate time worked: Start time, end time, lunch break
    By welchs101 in forum Excel General
    Replies: 7
    Last Post: 04-25-2020, 03:23 AM
  2. [SOLVED] Working time if statement - say "yes" if time is greater than 8.00am and less than 17.15pm
    By Ainsley in forum Excel General
    Replies: 4
    Last Post: 03-14-2014, 07:08 AM
  3. Excel 2007 : Elaped military time when actual start time before scheduled start time
    By cro1010 in forum Excel General
    Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  4. End time to be greater than start time
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2009, 09:13 PM
  5. display end time automatically upon entering start time and time usage
    By stoey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2008, 06:16 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1