The analysis is as follows:
1, first of all, the department information and personnel information are all ready.
2. Then define the company's schedule after work, set attendance rules and shifts, and assign personnel shifts.
3. After the above completion, employees will record the attendance data after punching in and out from the fingerprint punching machine and make statistics. After the statistics are completed, you can read attendance list, attendance daily report, attendance summary table, attendance exception table, overtime statistics table, leave summary table and so on.
Extended data:
The attendance sheet is a voucher for employees to go to work every day, and it is also a voucher for employees to get paid, because it records the number of days employees go to work. There are specific commuting times in the attendance sheet, including being late, leaving early, absenteeism, sick leave, personal leave and vacation. The time sheet can be used as "evidence" of the text.
References:
Baidu encyclopedia timetable
Punching records are converted into attendance sheets.
Connect the USB flash drive to the attendance machine and enter the management interface. There is data management for downloading attendance data. After downloading, connect to the computer and enter the attendance software. In the software data, choose U disk management, and the last one is self-service fingerprint punching to import records into the computer. After that, you can make statistics in query/print.
1, the computer needs to install "Attendance Management System Standard Edition", insert the USB flash drive and open "Attendance Management System Standard Edition".
2. Open Data -u disk management and press ""to confirm.
3. In the pop-up window, select the 9-digit code.
4. Click "Import Record Data into Computer" at the top, and then click "Import Records from U Disk" on the right.
5. In the pop-up dialog box, click OK to start importing data.
6. We can enter the corresponding time period in "Attendance Record" and click "Query" to view the imported data.
How to quickly check the attendance of more than 300 people?
If you want to quickly check the attendance of more than 300 people, let each department check it separately and then summarize it.
How to automatically count the clock-in records when they are converted into attendance sheets?
Excel is a widely used office software. Excel comes with many functions, which can help you edit tables better. Today, I will share with you how to make an attendance sheet with excel and automatically calculate the attendance days. Let's have a look!
1, open the excel software on the computer.
2. Open a new table. You can write your company name and month for the title according to your own needs, and then merge the cells in the center. Subtitle can enter information such as department and attendance clerk. Subtitles can be written or not, depending on the needs of your company.
3. Enter the date and name in the title to divide rows and columns, with the name of row and the time of column. Enter the date first, press alt+ ENTER, and then enter the name. Alt+ Enter means a line break in a cell. When you are finished, put the cursor before the date, and then press the space bar to move back to the far right of the cell.
4. After input, select the cell and click the right mouse button, and select the format cell in the pop-up menu item.
5. In the border page with pop-up cell format, select the diagonal line on the right to divide the border, and then click OK.
6. Enter the date of the column. Take August as an example, from 1 to 3 1, enter 1 in the first column, drag the mouse backwards to fill in the sequence format, and the cells will automatically fill in 1 to 3 1.
7. It is the input of late attendance, etc. If you input one by one, it will be more troublesome. You can set an order here, and use symbols to indicate lateness, absenteeism and leave, as shown in the figure.
8. Enter employee attendance in the attendance area.
9. To calculate the attendance days of employees, just use the countif function. For example, in the column of recent statistics, enter the formula =COUNTIF in the first row.
10. After the input is completed, press Enter on the keyboard to calculate the result.
1 1. Click the small square in the lower right corner of the cell and drop it down to the last row, and the attendance results of this column will come out.
12, otherwise the calculation method of the result is the same, and the countif function is also used, just change the corresponding sign.
The above is all about how to make an attendance sheet with excel and automatically calculate the attendance days.
How to sort out irregular punch-in attendance records
The transfer method of irregular attendance and punching records is as follows:
First, create a new attendance result table, place employee names vertically and dates horizontally, and then enter the formula in cell B2:
=IF*), IF**), "normal", "early leave"), "late"), "absenteeism")
According to the above vernacular formula, you can fill in the corresponding data directly. It should be noted that 9/24 means 9: 00, 17.5/24 means 17: 30, similarly, 8: 30 means 8.5/24, 18: 00 means 18.