+ Reply to Thread
Results 1 to 4 of 4

chart a table of consistent lateness for one person in a range of names and times

  1. 04-15-2021, 08:28 PM #1
    Por2gal
    Por2gal is offline
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    79

    chart a table of consistent lateness for one person in a range of names and times

    Hello fellow members/helpers
    I am at a stand-still.
    I am trying to calculate the number of times a person is late due to the days and months of the related sheets.
    I need to chart, one named person, from a certain number this person is related to, out of several names and numbers.

    I have 'highlight' the row of the name and number I am referring to in the sheet I have attached.
    I would like to find out how many times number '10' named 'J' [highlighted] has been late or early or on time over a period of 3 months?
    I would like to chart a table just on this result only from a period of 3 months which I have placed on 3 sheets.

    Please Help and I look forward to your response with much gratitude
    Thanking you in advance
    Diana
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-20-2021, 09:13 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: chart a table of consistent lateness for one person in a range of names and times

    For the layout of the data this would be my proposal, as modeled for the Sign On's.
    1. Populate XFB3:XFD30 using: =SUMPRODUCT(($A$3:$A$151=$A3)*($B$1:$W$1=XFB$1)*($C$3:$X$151=XFB$2))
    2. As modeled on Sheet1, populate B3:D30 using: =SUM('Nov PM Diff:Sep PM diff'!XFB3)
    3. Produce a pivot table from the data in B3:D30
    4. The pivot table may be filtered so that the pivot chart will show the early, on time and late values for a particular person.
    The above steps can be similarly applied to the Arrive and Leave data also.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 01-23-2024, 06:08 PM #3
    Por2gal
    Por2gal is offline
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    79

    Re: chart a table of consistent lateness for one person in a range of names and times

    thank you JeteMc
    your calculation has greatly helped me.
    Reply With QuoteRegister To Reply
  4. 01-23-2024, 10:35 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: chart a table of consistent lateness for one person in a range of names and times

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. list on excel that tracks how many times person a has been with person b or they have been
    By wingingithere in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-03-2019, 01:21 AM
  2. [SOLVED] Pivot Table/Chart where person moves team.
    By BigErnKingpin in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 01-31-2017, 09:50 AM
  3. Using VBA to maintain consistent bar chart colors
    By bighitter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2016, 05:01 PM
  4. Change bar chart colors to be consistent with another chart
    By Larry.LeBlanc@O in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-17-2014, 08:26 PM
  5. [SOLVED] count number of times a text appeared in a month in given range of dates and names
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2014, 08:27 AM
  6. Pad axis numbers so that chart width is consistent throughout a range of charts.
    By Reimund Trost in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-28-2013, 03:02 PM
  7. Searching for times by date and person
    By nigeli in forum Excel General
    Replies: 1
    Last Post: 08-14-2012, 10:49 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1