How to separate the records of two devices in the attendance machine

Yes, the attendance machine can also be used as a time-counting dining machine, we use the system of the branch, you can set whether it is dining or attendance when communicating, and the data collection will enter different places (as shown in the figure below). Otherwise, you can import to excel and see if there is a machine number sorting, and it would be much better if there is.

Nowadays, very few machines can distinguish records by machine number. Although the records are listed as machine number 1 and machine number 2, the records are still completely separated.

So there is only one way to do it, which is to export the records to excel first, and put all the rows of machine number 1 together through the excel filter sorting tool, put all the rows of machine number 2 together, and then put them in two ** and then count.

Some induction attendance machines and some are fingerprints, separate statistics, separate management, you put them together, you must count the dead.

If many records are exactly the same, the most likely action is:

1. The device A machine number is 001, and the data is collected with the attendance software.

2. The machine number of device B is also 001, and it is found that the machine number is the same, and the machine number of equipment A is changed to 002, and the data is collected.

The attendance records between the two devices will not be confused, and the registration information can be sent through the attendance software to become the same.

If the individual records are the same, it should be that the individual employee clocked in and out on the two machines.

I have connected more than one attendance machine, if I check the card on that attendance surface.

Connecting multiple devices with the same software is to aggregate the data of multiple devices by default, and if you want to view the attendance data separately, it is recommended that different attendance machines use different software to do attendance. If you want to use the same software, you can refer to the following operations:

Find the icon on the computer desktop, right-click - open the file location - right-click to copy and paste, create multiple databases (paste a few times on several attendance machines), and then change the name to distinguish it;

Then open the software maintenance settings - database settings - connection - select the corresponding database, after entering each database, leave the corresponding machine, delete the other machines, and then connect to a database operation for each attendance machine data.

Attendance report settings.

Insert the USB flash drive first;

Click the "M OK" button, select "Report Management" and click the "M OK" button again;

Use the computer to open the settings report in the USB flash drive, there are two tables in the table;

This is the attendance setting table, setting the shift; Just set the first time slot of shift 1: 9:00 a.m. and 5:30 p.m

2. After the shift is scheduled, another shift setting needs to be set; Enter the month of the month on the statistical date, e.g. 2013-4-1; Then, enter the consultant's name in the "Name" column for the corresponding employee number, change the "Department" to the consultant, and enter "1" for all dates and shifts.

3. After setting up the report, save it, and then upload the report to the attendance machine. Click the "M OK" button to select "Report Management" and click the "M OK" button again, and select "Upload Setup Report" after entering the interface.

4. After the report setting is completed, the report needs to be set again once a month.

Select the data - click on the data options - select the column.

In Text Column Wizard 1, select the separator symbol, Next.

In Text Column Wizard 2, tick the space and go Next.

In Text Column Wizard 2, tick the space and go Next.

In Text Column Wizard 3, select General and click Done.

The commute time will be split into two cells.

b3=timevalue(left(b2,5)) other horizontal pull b4=timevalue(right(b2,5)) other horizontal pull two formulas are set in the cell format: +1 number time 13:30b5=b4-b3 formula set in cell format:

1 number time 13 hours 30 minutes.

That is, the meaning of b5: the time difference between the two is 8 hours and 44 minutes.

Clock-in hours formula.

left(b2,5)

Off-duty time formula.

right(b2,5)

This can be achieved with formulas.

Take a look at this formula:

number of hours worked; The formula for cell f5 is: =text(f4-f3,"hh:mm"), pull right to fill other cells.

If in doubt, you can continue the discussion!

The formula for working hours is changed to: =if(and(b5<>"",b4<>""),text(b5-b4,"hh:mm"),"")

Where did you buy it? When you buy an attendance machine, you buy after-sales.

All Easy Access reminds you:

Here's how you can do it:

1. Let everyone register their faces and information on one of the attendance machines, and then upload all the personnel information on this machine to the other attendance machine.

2. Set the numbers of the two attendance machines to machine No. 1 and machine No. 2 respectively.

The person's employee has the same job number on both machines.

Set up the connection number, respectively No. 1 and No. 2, upload the personnel of the first station to the computer, and then transfer it to the second station.

This is done in the personnel registration.

Set the machine number and upload the data.

Is the data the same for the 2 robots?

In the same case, import it into the software of a computer.

Not the same: The attendance number of the required person is not duplicated. If it's repeated, it won't.