+ Reply to Thread
Results 1 to 4 of 4

Late Coming Calculation

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Late Coming Calculation

    Dear Experts

    In attached sample sheet, for each person I would like to know how many times the IN is greater than 10:05. How can i do this please
    Attached Files Attached Files

  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
    Posts
    51,250

    Re: Late Coming Calculation

    Your "in" times are text, not real time
    Use this in a helper column (I used G)...
    G2=TIMEVALUE(F2)
    copied down

    Then create a list of unique names. I did a quick list by copying all the names into I, then removing duplicates.

    For your list...
    =COUNTIFS($G$2:$G$1000,">10:05",$C$2:$C$1000,I2)
    copied down
    I
    J
    1
    Full Name
    2
    Shubham Mishra
    13
    3
    Dhanalakshmi
    0
    4
    Sumalatha
    0
    5
    Nayana
    2
    6
    Lavanya N
    2
    7
    Shivaranjini
    6
    8
    Pallavi S
    3
    9
    Shashank Singh
    2
    10
    Shubha K
    6
    11
    Chaya Kumar Swamy P
    4
    12
    Pooja J
    4
    13
    Bhavana C S
    1
    14
    Manjunath R
    0
    15
    Lalitha T S
    7
    16
    Nidhi Pansari
    0
    17
    Shoib Ulla Khan
    2
    18
    Riya Jain
    3
    19
    Shyam .Sundar
    3
    20
    Ravi Kumar .C
    3
    21
    Ramesh
    15
    22
    Anand R
    0
    23
    Manoj M
    0
    24
    Kavya N
    0
    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
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    Re: Late Coming Calculation

    Thank you can you please share excel sheet how it is done please

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

    Re: Late Coming Calculation

    I thought I explained pretty well, but here is your file
    Attached Files Attached Files

+ 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. Late/Tardiness Hours calculation per interval
    By Tanekuma01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2020, 09:47 AM
  2. Calculation of late entries of employees
    By mgoutam in forum Excel General
    Replies: 3
    Last Post: 02-24-2018, 09:35 PM
  3. [SOLVED] Time calculation for attendance, tardy/late to work?
    By Hanr3 in forum Excel General
    Replies: 7
    Last Post: 12-08-2015, 06:16 AM
  4. late comming and ealy going calculation
    By anjana arora in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2014, 01:43 PM
  5. Late payment penalties (Calculation)
    By tric_maq in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2013, 02:30 PM
  6. COMPLICATED late payment charge calculation on arrears and fixed cost
    By tric_maq in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-04-2013, 08:02 AM
  7. Late or On Time Calculation
    By concretetsunami in forum Excel General
    Replies: 7
    Last Post: 03-24-2008, 04:26 PM

Tags for this Thread

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