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.


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.

Header of Weekly Labour Attendance Sheet in Excel Format

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

Header of the Columns of Weekly Labour Attendance Sheet in Excel Format

  • In this regard, to make the proper format for dates, select merged cells C6 and F6.
  • Subsequently, press Ctrl + 1.

Access the Format Cells Window

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

Format Cells Window

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

Create Formatted Rows in Labour Attendance Sheet in Excel Format

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.

Access Format Cells Window

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

Format Cells Window

  • Afterward, put the entry and exit times in the respective cells for respective days and respective employees.

Time Records of Labour Attendance Sheet in Excel Format

Read More: How to Make Time Attendance Sheet in Excel (2 Easy Ways)


Similar Readings


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

Access Format Cells Window

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

Format Cells Window

  • At this time, click on cell E8 and insert the following formula.
=D8-C8
  • Subsequently, press the Enter key.

Formula to Calculate Total Time Worked in Labour Attendance Sheet in Excel Format

  • Afterward, place your cursor in the bottom right position of the cell.
  • Subsequently, drag the fill handle below upon its arrival.

Drag Fill Handle Below

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

Total Time Calculated in Labour Attendance Sheet in Excel Format

  • Similarly, use your fill handle feature to get the employees’ total working time for that particular day.

Labour Attendance Sheet in Excel Format

Repeat the same procedures for all the weeks and get all the weeks’ working time for all employees.

Week 2 Labour Attendance Sheet in Excel Format

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.

Formula to Calculate Total Weekly Time Worked

  • At this time, drag your fill handle below to copy the same formula for all the cells below.

Drag Fill Handle 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.

Formula to Calculate Total Time Worked in Week in Labour Attendance Sheet in Excel Format

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

Monthly SUmmary of Labour Attendance Sheet in Excel Format

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!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo