1. Company name, date, department head, general department reviewer, and attendance person.
2. Employee’s name, job number, and position.
3. In the early days, attendance usually consisted of signing a name in a record book with a pen;
4. Since substitution occurs from time to time, biometric identification and access control card swiping are usually used to check attendance.
5. Some companies have independent ERP office systems and attendance management systems.
General tips for employee time sheets
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)
Recommended by the editor of Huajun Software Park
Employee attendance sheetIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Accounts receivable management table,Personal daily income and expenditure record detailsDownload to get the source file, which you can edit, modify and replace. To download the employee attendance sheet, go to Huajun Software Park.
it works
it works
it works