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)
Bookmarks