Tanjim Reza
Excel is extremely useful for making various complex templates. An attendance sheet is frequently needed thing industries, corporations, and institutions. With Excel, we can effectively create an attendance sheet. In this article, I will show you all steps to create a labour attendance sheet in Excel format.
Download Practice Workbook
You can download our practice workbook from here for free!
Steps to Create a Labour Attendance Sheet Format in Excel
Suppose, you have 10 laborers in your institution. You can create an attendance sheet for them by following the step-by-step guidelines below.
📌 Step 1: Prepare a Weekly Labour Attendance Sheet Format
First and foremost, you need to prepare a format of weekly labor attendance sheet in Excel.
- To do this, at the very beginning, create some heading about the month and week number of your labour attendance Excel sheet in cells B4 and B5.
- Afterward, in rows 6 and 7 create the headers for Employee names, dates, entry time, exit time, and total working time like the format below.
- In this regard, to make the proper format for dates, select merged cells C6 and F6.
- Subsequently, press Ctrl + 1.
- As a result, the Format Cells window will appear.
- Following, go to the Number tab here >> choose Date from the Category: pane >> select Wednesday, March 14, 2022 option from the Type: pane >> click on the OK button.
- As a result, the format of the dates will be proper.
- Afterward, select 8 rows of your created labour attendance Excel sheet format >> click on the All Borders icon from the Home tab >> click on the Middle Align icon from the Home tab >> click on the Center icon from the Home tab.
As a result, your labor attendance sheet in Excel format is ready to take inputs.
Read More: Make Automated Attendance Sheet in Excel (With Easy Steps)
📌 Step 2: Record Entry Time & Exit Time of Labourers
The next thing you need to do is to record the employee names, and entry and exit times.
- In order to do this, initially, put the employees’ names in cells B8:B15.
- Afterward, select cells C8:C15, D8:D15, F8:F15, and G5:G18.
- Subsequently, press Ctrl + 1.
- As a result, the Format Cells window will appear.
- Following, go to the Number tab here >> choose Time form Category: pane >> choose 1:30:55 PM option from the Type: pane >> click on the OK button.
- Afterward, put the entry and exit times in the respective cells for respective days and respective employees.
Read More: How to Make Time Attendance Sheet in Excel (2 Easy Ways)
Similar Readings
- Attendance and Overtime Calculation Sheet in Excel
- How to Create Monthly Attendance Sheet in Excel with Formula
- Attendance Sheet in Excel with Formula for Half Day (3 Examples)
- QR Code Attendance Tracking with Excel (with Easy Steps)
- Attendance Sheet with Salary in Excel Format (with Easy Steps)
📌 Step 3: Calculate Total Time Worked by Labourers
Afterward, you need to calculate the total time worked by the employees each day.
- To do this, first, select cells E8:E15, and H8:H15.
- Following, press Ctrl + 1.
- As a result, the Format Cells window will appear.
- Subsequently, go to the Number tab here >> choose the Time option from the Category: pane >> choose the 13:30 option from the Type: option list >> click on the OK button.
- At this time, click on cell E8 and insert the following formula.
=D8-C8- Subsequently, press the Enter key.
- Afterward, place your cursor in the bottom right position of the cell.
- Subsequently, drag the fill handle below upon its arrival.
- As a result, all the employees working time will be calculated for the particular day.
- Afterward, click on cell H8 and insert the following formula.
=G8-F8- Subsequently, hit the Enter key.
- Similarly, use your fill handle feature to get the employees’ total working time for that particular day.
Repeat the same procedures for all the weeks and get all the weeks’ working time for all employees.
Read More: How to Create Employee Attendance Sheet with Time in Excel
📌 Step 4: Prepare a Monthly Summary for Labourers
Last but not least, you need to prepare a monthly summary for the laborers now.
- For doing this, at the very beginning, click on cell C7 and insert the following formula.
=SUM('Week 1'!E8,'Week 1'!H8)- Subsequently, press the Enter key.
- At this time, drag your fill handle below to copy the same formula for all the cells below.
- Afterward, click on cell D7 and insert the following formula for Week 2 total working hours.
=SUM('Week 2'!E8,'Week 2'!H8,'Week 2'!K8,'Week 2'!N8,'Week 2'!Q8)- Subsequently, hit the Enter key.
- Afterward, drag your fill handle below again to copy the same formula for all the cells below.
- Repeat the same procedures for other weeks.
Thus, you will get your complete labor attendance sheet in Excel format. And, the format would look like the following.
Read More: How to Create a Monthly Staff Attendance Sheet in Excel
Conclusion
So, in this article, I have shown you all the steps to create a labor attendance sheet in Excel format. I suggest you read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are welcome to comment here if you have any further questions or recommendations.
And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!
