Results 1 to 3 of 3

find the min and max of the time of the date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-17-2008
    Posts
    156

    find the min and max of the time of the date

    Hi there

    I have a date column, time column and a column message text with "Access" or "Exit"

    i trying to find the :
    (1) Earlier time of the Access of that Day of every given date
    (2) And in between "Access" and "Exit" , what is the max duration of every given date?
    (3) Lastly, the latest "Exit" time of the every given date

    attached the data sample.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find a date time range within start and stop date time?
    By Rodney Fernandes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2017, 02:19 AM
  2. [SOLVED] Find Date and Time for a value
    By hanif in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2016, 06:03 AM
  3. [SOLVED] find second to last date & time
    By SHAYJOSH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2016, 02:30 PM
  4. Replies: 1
    Last Post: 03-16-2016, 08:19 PM
  5. Replies: 4
    Last Post: 12-12-2014, 08:03 AM
  6. find first & last date/time
    By y_not in forum Excel General
    Replies: 3
    Last Post: 07-12-2011, 06:43 AM
  7. find date & time
    By rob in forum Excel General
    Replies: 1
    Last Post: 09-19-2005, 06:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1