Employee attendance summary is something that HR has to do every month, and it is also the basic work for salary payment.
Keeping attendance records ready for reference at any time can often help many employees' interest demands.
For example, the most worrying question for HR - "Is the salary calculation wrong?"
For this reason, the editor has taken great pains to compile a set of "Employee Attendance Excel Template" which will definitely be helpful to you!
Table function features
Each worksheet is automatically linked, and the attendance view can dynamically display employee attendance status, including various types of leave status, at a glance!
This attendance Excel template has two main functions, attendance view and leave summary.
Attached is the form download method at the end of the article.
Table display
The attendance view can dynamically display employees' attendance status, including various leave status, at a glance.
Selecting different employees will automatically pop up different views. The animation is shown below:
The employee's personal attendance calendar will automatically change color, and different colors represent different attendance statuses.
For example, sick leave is blue and wedding leave is pink, and the specific vacation time is also clear at a glance.
The function of photochromic requires a lot of effort to achieve. Let’s take the sick leave display in blue as an example.
Setup steps
1. Select the attendance sheet area and go to Start - Conditional Formatting - New Rule
2. Use formulas to determine the cells to be formatted and enter the formula
=COUNTIFS(Employee vacation!$E$8:$E$26,"Sick leave",Employee vacation!$C$4:$C$26,"<="&C6,Employee vacation!$D$4:$D$26, ">="&C6)=1
Of course, you don’t have to work hard to make this attendance form, because the editor has already packaged it. If you need the original copy of this form, HR friends, please get it and check it again.
How to get it for free: Please follow "Sanmao.com" headline number, send a private message with the keyword "News", and the system will automatically send it to you Information! (No routines, no need to share operations)
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/dong-tai-yuan-gong-kao-qin-biao-xls-ling-zi-liao-la.html
支付宝扫一扫 
评论列表（196条）
测试