Tips for using the punch record sheet
punch record sheetPreparation of:
1. The attendance staff is responsible for registering the attendance and absence of each employee.
2. Obtain the attendance status of students, employees or certain groups or individuals in a specific place and within a specific time period through some means.
3. Use a pen to sign your name in the record book.
1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
The punch-in record form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the punch-in record form, please download it quickly.Debon Logistics Freight Price List,Case observation record form for large class childrenIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works