+ Reply to Thread
Results 1 to 7 of 7

Attendance Tracker

  1. #1
    Registered User
    Join Date
    03-04-2008
    Posts
    3

    Attendance Tracker

    Hi. I have an attendance tracker created for work, on a weekly basis I need the ir attendance percentage. Im sure its pretty simplistic of a formula, and whoever gives me this answer is my God forever!

    Basically, its a 5 day work week. Their attendance is marked A= Absent(0%), P=Present(20%), LS=Late Start(10%), LE=Leave Early(10%). I just need to add up the 5 days for each worker, and input it into another cell with their attendance percentage. So essentially they work 4 days = 80% attendance...3 days = 60%...etc.

    If I confused anyone and you need to see a spreadsheet to understand, just ask.

    Thanks SO much in advance!

    Shanny

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,406
    Hi,

    Presuming your attendance data is in row 1 from column A to E,

    =COUNTIF(A1:E1,"P")*20+COUNTIF(A1:E1,"LS")*10

    will yield the attendance score you are trying to calculate.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    03-04-2008
    Posts
    3

    Talking

    Great, worked like a charm! Thanks!!!

  4. #4
    Registered User
    Join Date
    03-04-2008
    Posts
    3
    Yet another stupid question. So i came up with a huge formula, but its fine, its working.

    =COUNTIF(C4:O4,"P")*20+COUNTIF(C4:O4,"A")*0+COUNTIF(C4:O4,"T")*20+COUNTIF(C4:O4,"LS")*10+COUNTIF(C4:O4,"LE")*10+COUNTIF(C4:O4,"LS1")*0+COUNTIF(C4:O4,"LE1")*0+COUNTIF(C4:O4,"TRN")*20

    Question is I have like 80+ staff that I need to use this, I'm sure theres an easier way to shift all the cell #'s down one...like instead of C4:O4, it'll be C5:05, then C6:O6, etc...Any ideas on how I do this?

  5. #5
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    Quote Originally Posted by shanny
    Yet another stupid question. So i came up with a huge formula, but its fine, its working.

    =COUNTIF(C4:O4,"P")*20+COUNTIF(C4:O4,"A")*0+COUNTIF(C4:O4,"T")*20+COUNTIF(C4:O4,"LS")*10+COUNTIF(C4:O4,"LE")*10+COUNTIF(C4:O4,"LS1")*0+COUNTIF(C4:O4,"LE1")*0+COUNTIF(C4:O4,"TRN")*20

    Question is I have like 80+ staff that I need to use this, I'm sure theres an easier way to shift all the cell #'s down one...like instead of C4:O4, it'll be C5:05, then C6:O6, etc...Any ideas on how I do this?
    2007 does it auto, try fill down, control D, if not copy past from mine
    Attached Files Attached Files
    Excel 2007 SP1

  6. #6
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Why are you including counts multiplied by zero.....? zero*anything = 0 so can be ignored.

    Ed

  7. #7
    Registered User
    Join Date
    12-14-2007
    Location
    Georgia
    Posts
    78
    I seen that but I did not relize, it lol... Dunno, I was just helping

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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