I just made an attendance sheet automatically generated according to the attendance record, but it contains information of other companies, so it is not easy to send it to you for reference.
You can send the attachment to my email, and I will help you write the formula, such as checking absenteeism and going to work.
[E-mail protected]
Ask the Great God: With attendance records, how to make an excel attendance sheet? 10 point
Friend, doesn't your punch card machine have attendance statistics function?
Requirement 1: The attendance is from 2 1 of the previous month to the 20th of the current month, and it is judged whether there is 3 1 of the previous month. Automatically judge the day of the week, so as to calculate overtime hours; Column e is a weekly column, copy the time of column d to column e, and then the unit format, date and day of the week are correct.
Requirement 2: Name automatically extracts non-duplicate data according to column B of Name.
Data "filtering" advanced filtering (automatic filtering is not commonly used), and selecting non-duplicate records will automatically filter out a single name.
Requirement 3: The punching time can be more than twice, and the value is: the earliest punching time-the latest punching time.
In theory, min and max functions can be used, but I don't know how to design them.
For example, A punched in twice at 08:14,08:18, and B punched in twice at 08: 09,08:10. If you circle the four times together, EXCEL has only one data at 08:09 per minute.
Excel original attendance record, how to make attendance sheet?
Just export it directly. The attendance sheet needs to write formulas, calculate attendance days and so on. . .
How to make the attendance sheet?
Did you sign in, or did you punch in with your fingerprint, or did you punch in? It's a fake sign-in, but you can see who is late every day. You can write a name, add 1 times later, and then write orthography. If you punch in with your fingerprint, you can see the punching time by downloading the punching letter and printing it out. See for yourself where it is late. Add up to some good punch cards, but you can directly see that you are late when you set them up. The perforation of the card is colored to indicate lateness. Just look at how many times Rhett is late, and you will know how many times he is late.
Finally, make a list of attendance days. How many days do you punch in? How late? . .
I hope this helps.
How to make attendance sheet by computer?
First, find out if you are using WORD ~ ~ ~ After opening WORD, click Insert where you need to insert it, find "tick" in the "Symbol" option box and click Insert.
How to make attendance sheet with excel for the data exported by fingerprint punching machine? 20 points.
There are shift settings and shift assignments in the attendance software. Set the company's shifts, assign shifts to personnel, download records from the attendance machine to the software, count attendance, and the attendance report will come out.
How to make attendance sheet with excel in attendance machine
1. First, as shown in the figure below, the first three lines are left blank. Enter the name in A4, starting with A4 and ending with H4, and add a border.
2. Select A 1:H 1 and select the merged cells.
3. Double-click the merged cells and enter the formula:
=TEXT(NOW (), "yyyy mm monthly attendance sheet")
Note: In order to prevent this function from changing automatically in June, you can paste it as a value at the end of the month and save it.
4. Enter 1 in B3 and fill in the date on the right. In this case, it is 7 days, that is, the current month 1 to 7.
Note: The actual situation can be filled in 3 1, and judged by IF. If it exceeds the maximum number of days in this month, it is empty.
5. Enter the first day of the month B2 and fill it in on the right.
Note: this can also be done by time formula. If the month and year are generated by the drop-down menu, both here and the header can be automatically generated by the formula and will not change with time.
6. Select the date you just entered, click the right mouse button, and then select the format cell. Input:
Aaaa, and then click the OK button.
7. In this way, the date just entered becomes the display style of "Day of the Week".
8. Enter the attendance mark in the unused blank field, then enter the option in the name box and press Enter. This defines the name of the option.
9. Select the blank position to the right of the name, and then select Data-Data Validity.
10. Select "Sequence" where allowed, enter the: = option in the source code, and check the drop-down arrow provided.
1 1. In this way, a drop-down menu is generated in columns B to H, which can mark the attendance of employees.
12. Select the drop-down menu of different dates according to the actual attendance of employees, and the effect after completion is as follows:
13. The last step is to count the attendance of the current month.
On the right side of the recording area, set the statistical format as shown below. Where I4:N4 is necessary for input formula statistics.
14. Double-click the I4 cell and enter the formula:
= COUNTIF($B4:H4,I$3)
Note: The reference to the original area and title in the formula needs special attention.
15. Then pull the formula to the right to return the employee's attendance statistics for the current month.
How to cover the attendance sheet printed by excel with A4 paper?
Adjust the row spacing and column width, and then adjust yourself to a larger size. A preview will display the page range with dotted lines, and try to adjust the contents of the attendance sheet to be slightly smaller than the dotted line range, so that the printed page is fuller and better-looking.
The data derived from the fingerprint punching machine, through how to make the attendance sheet
Ding Dong sign in and recommend it to you. It is more convenient to calculate and generate reports directly and export data in the background.
How to get 5 points for checking the number of employees' attendance sheets?
Right-click the keyboard icon in the input method switch, select the mathematical symbol, and check the key with a period √, which can also be copied and used.