# Creating a attendance record for office employee?

1. ## 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)

2. ## 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")

3. ## 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. ## 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

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

#### 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