+ Reply to Thread
Results 1 to 2 of 2

time_report_date-wise_employee-wise

  1. #1
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    298

    time_report_date-wise_employee-wise

    I am having date-wise, employee-wise login logoff data in Col A to C as under

    DATE EMP_NO TIME

    01/03/2014 1525336 09:04
    01/03/2014 1525336 09:04
    01/03/2014 1525336 09:27
    01/03/2014 1525336 09:41
    01/03/2014 1525336 09:58
    01/03/2014 1525336 10:06
    01/03/2014 1525948 10:14
    01/03/2014 1525948 10:14
    01/03/2014 1525948 10:22
    01/03/2014 1525948 10:47
    03/03/2014 1525336 10:13
    03/03/2014 1525336 10:53
    03/03/2014 1525336 10:59
    03/03/2014 1525336 11:04
    03/03/2014 1525336 11:19
    03/03/2014 1525336 11:36
    03/03/2014 1525948 10:16
    03/03/2014 1525948 10:17
    03/03/2014 1525948 10:17
    03/03/2014 1525948 10:18
    03/03/2014 1525948 10:18
    03/03/2014 1525948 10:37
    04/03/2014 1525336 10:09
    04/03/2014 1525336 10:13
    04/03/2014 1525336 10:23
    04/03/2014 1525336 10:43
    04/03/2014 1525948 10:12
    04/03/2014 1525948 10:13
    04/03/2014 1525948 10:14
    04/03/2014 1525948 10:14
    04/03/2014 1525948 10:20

    What I want is date-wise, employee-wise login (starting time) logoff (ending time) report for each of the employees in a separate sheet as example given for the above list as under;

    DATE EMP_NO LOG_IN LOG_OUT
    01-03-2014 1525336 09:04 10:06
    01-03-2014 1525948 10:14 10:47
    03-03-2014 1525336 10:13 11:36
    03-03-2014 1525948 10:16 10:37
    04-03-2014 1525336 10:09 10:43
    04-03-2014 1525948 10:12 10:20

    Help please.

    Regards.

    -via135

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,674

    Re: time_report_date-wise_employee-wise

    Array formula (ctrl+Shift+Enter commited):
    =MIN(IF(($A$2:$A$32=F2)*($B$2:$B$32=G2),$C$2:$C$32,""))

    and the same with max
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. sum by month wise and staff wise horizontal and vertical
    By cjjimmy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 04:07 AM
  2. Excel code to represent data from row wise to column wise
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 03:45 AM
  3. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  4. Supplier Wise month wise totaling
    By Hussain_smh in forum Excel General
    Replies: 3
    Last Post: 02-25-2012, 03:34 PM
  5. [SOLVED] Delete row wise duplicates & colomun wise simultaneously excel
    By Dipankar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 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