1. Create a new blank excel sheet.
2. Modify employee information and date.
3. Enter information such as working hours, overtime, etc.
What is the use of the attendance form?
1. The attendance sheet is a voucher for company employees to go to work every day, and it is also a voucher for employees to receive wages, because it records the number of days that employees work. The time sheet contains the specific starting and get off work times, including late arrival/leaving early/absenteeism/sick leave/personal leave/vacation. Time sheets can serve as "evidence" of the text.
2. Employees do not need to fill in the attendance form themselves.
3. Function: Mainly used as the basis for salary payment.
The general affairs staff of the office or other designated personnel should fill in the attendance form.
General Tips for Downloading Attendance Sheet Spreadsheets
1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
Recommended by Huajun editor
Attendance form download electronic formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Universal Registration Form,Inventory entry and exit details listDownload to get the source file, which you can edit, modify and replace. To download the attendance sheet and download the spreadsheet, go to Huajun Software Park.




















Useful
Useful
Useful