+ Reply to Thread
Results 1 to 4 of 4

Creating a attendance record for office employee?

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    Nagercoil
    MS-Off Ver
    Excel 2010
    Posts
    2

    Cool Creating a attendance record for office employee?

    Hi All,
    I am working on this excel sheet for a small business to track the employee's monthly attendance record and I am almost done with most part of it, now i need to calculate the attendance automatically based on the given values I need "P" to count in the column "Total No. Of Days Present" and value "A'" to count in the column "Total No. Of Days Absent", which I did using "COUNTIF" function, now i need to add up the value "H.F" as count 0.5 to the column "Total No. Of Days Present" Basically its like

    P = Present (Increment by 1)
    PL = Paid Leave (Increment by 1
    HF = Half day (Increment by 0.5)
    A = Absent (Decrement by 1)

    I've also attached the excel which I've created so that its easy for you to understand..

    In the attachment I've only (Total No. Of Days - Total No. Days Absent)
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,943

    Re: Creating a attendance record for office employee?

    would a countIF work for you

    =COUNTIF(C4:AG4,"P")+(COUNTIF(C4:AG4,"A")*-1)+(COUNTIF(C4:AG4,"HF")/2)+COUNTIF(C4:AG4,"PL")
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-24-2013
    Location
    Nagercoil
    MS-Off Ver
    Excel 2010
    Posts
    2

    Talking Re: Creating a attendance record for office employee?

    IT WORKED !!!

    Thank You so much, I was thinking in all directions but not straight.... All this time I didn't know how to do that since I'm a newbie to excel sheets ..

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,943

    Re: Creating a attendance record for office employee?

    you very welcome- glad its worked out

    if you wish to , and only if you wish to, there is a reputation icon * on the left hand side - you can add to my reputation here

+ 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