Create a Attendance in ms excel follow this
To the right of each monthly employees Registered ( the row for a employee is Present, Absent, counted and employee Attendance calculated. At the bottom of each daily record the column for a day the total number of employees, present absent that day is automatically counted.
Instruction for use
Entering month, and employees name use the following name format to ensure consistency when all registered employee name have been enter in this column B if you have not entered alphabetically you can sort them by by doing the following. identify a employee attendance .
P-present, and A-absent if you want to use different character or symbles enter then into cells all other cells o the monthly attendance template will update then cells.
To the right of each monthly employees Registered ( the row for a employee is Present, Absent, counted and employee Attendance calculated. At the bottom of each daily record the column for a day the total number of employees, present absent that day is automatically counted.
Instruction for use
Entering month, and employees name use the following name format to ensure consistency when all registered employee name have been enter in this column B if you have not entered alphabetically you can sort them by by doing the following. identify a employee attendance .
P-present, and A-absent if you want to use different character or symbles enter then into cells all other cells o the monthly attendance template will update then cells.
Find Present from Countif Formula --------------------------------- =countif(E3:AH3,"P")
Find Absent from Countif Formula --------------------------------- =countif(E3:AH3,"A")
0 comments:
Post a Comment