Labour Attendance Sheet Format in Excel (Create with Easy Steps)

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.

Labour Attendance Sheet Format in Excel: with Easy Steps

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.

📌 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.

📌 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.

📌 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.

Download Practice Workbook

You can download our practice workbook from here for free!

Labour Attendance Sheet.xlsx

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.

<< Go Back to Employee Attendance Sheet Excel | Excel HR Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!