+ Reply to Thread
Results 1 to 6 of 6

Formula to return earliest and latest time.

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    250

    Formula to return earliest and latest time.

    Anyone knows a formula that can return the earliest or the latest time for a specific name?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: Formula to return earliest and latest time.

    take a look at the =MIN(IF()) and MAX(IF()) array formulas
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    964

    Re: Formula to return earliest and latest time.

    have sample data? Try this and if you have issues, share a sample hit ALT+X to go advanced and post the file or a mockup of that file

    The following are Arrays
    CTRL+SHIFT+ENTER after typing them in adds the {} around the formula -

    Min IF Statement (Do not declare a false in your If as it will only apply if it is true)
    Please Login or Register  to view this content.
    Max IF Statement
    Please Login or Register  to view this content.
    -If you think you are done, Start over - ELeGault

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    964

    Re: Formula to return earliest and latest time.

    Ford -
    yes.................
    ..Bahahahaaa


    I was going to say... Statement or Question?

    Anyone knows a formula that can return the earliest or the latest time for a specific name?
    Last edited by ELeGault; 12-06-2014 at 11:11 PM.

  5. #5
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 365 (Newest version)
    Posts
    250

    Re: Formula to return earliest and latest time.

    Thanks alot...just saved me from hell....lol

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,341

    Re: Formula to return earliest and latest time.

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Looking Up Earliest and Latest Time Values
    By warhead92100 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-25-2013, 06:07 AM
  2. How to Get Earliest Time In and Latest Time Out
    By domzki225 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-20-2013, 04:55 PM
  3. Earliest and Latest Time where cell contains certain text
    By asalbus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2013, 01:45 AM
  4. [SOLVED] Calculate time durations for a roster, and indentify the earliest and latest times
    By bajdr47 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-25-2012, 04:47 PM
  5. Excel 2007 counting of earliest and latest time
    By pvesterberg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2010, 03:21 AM

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