Results 1 to 3 of 3

Thread: Help: Minimum entry time given a referenced date

  1. #1

    Help: Minimum entry time given a referenced date

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, hope someone can help me out.
    This is my problem: I want to use the date in the fourth row to look for the earliest time in the 2nd row given the date.
    I can't seem to work it out, I've tried a variety if min-if formulas and index min match.

    date time start time end date start time
    12/1/16 8am 930am 12/1/16
    12/1/16 930am 2pm 12/2/16
    12/1/16 2:30pm 5pm 12/3/16
    12/2/16 8am 11am
    12/2/16 12pm 4pm
    12/3/16 7am 2pm
    12/3/16 2pm 3pm
    12/3/16 3pm 5pm

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    If you add a file attachment with the expected results and your attempt at calculating, perhaps someone help you because it will be clearer
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Excel Version
    if the cell top left of your table which contains the header date is in cell A1, then in E2 array-enter (that's Ctrl+Shift+Enter, not just Enter) the formula:
    then copy it down, you might get your answers.

Posting Permissions

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