+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    01-10-2019
    Location
    Auckland, New Zealand
    MS-Off Ver
    2013 home
    Posts
    54

    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

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,881

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1