The simplest PivotTable report uses name and date columns, whether you are late or leave early. After creating a PivotTable report on a new worksheet, drag the name to the row area, drag the date to the data area, and automatically create a Count Item: Date for you.

The attendance machine is actually composed of a complete single chip microcomputer. To put it simply, its principle and working process are as follows: the attendance machine has its own clock circuit, and the user swipes the card at a certain time point. The attendance machine automatically stores the time point (year, month and day) information and card number information as original records in the memory chip of the attendance machine, and the administrator finally sends these original data to the computer through the data line (common serial port and the development of TCP/IP network cable, etc.), and the computer has installed special supporting attendance.