11 Replies Latest reply on Nov 26, 2013 1:20 PM by Mark Smith

    I have an event time, need to check against time log to verify event time was between times on time log

    James Keuning

      I am attaching a workbook with sample data.

       

      Events contains a userID and a time/date stamp.  I need to check each event against the TimeLog and make sure that the event logged falls inside the Max and Min times for the given user and date.  I am looking for accuracy to the second.

       

      Anyone have any thoughts on where I should start?