Excel Daily Labour Attendance Template

Walter Jul 15, 2026

In the modern workplace, tracking daily labor attendance has become a critical aspect of operations management. Excel, with its robust set of tools and formulae, offers an efficient way to create labor attendance sheets. Let's delve into crafting an Excel sheet for daily labor attendance, complete with formulae that streamline the tracking process.

the information sheet is displayed in this screenshote screen shot from www ms officegeeek com
the information sheet is displayed in this screenshote screen shot from www ms officegeeek com

Before we begin, ensure you have Microsoft Excel installed. If you're new to Excel, don't worry. This guide will walk you through everything you need to know to create an effective daily labor attendance sheet.

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

Setting Up the Basic Structure

First, let's set up the basic structure of your Excel sheet. Open a new workbook and save it with a relevant name, such as "DailyLaborAttendance". In the first row, starting from the first column, create the following headers: 'Date', 'Employee Name', 'Check-in Time', 'Check-out Time', and 'Total Hours'.

“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”

Format the 'Date' column as an 'exact' number, which allows for easy sorting and filtering later. Freeze the top row by clicking anywhere within the data and then selecting 'View' > 'Freeze Panes' > 'Freeze Top Row'. This keeps your headers visible as you scroll through the data.

Automatic Date Insertion

🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel

To save time, automating the date insertion can be beneficial. In the second row, in the 'Date' column, type "=TODAY()" and press Enter. This formula inserts the current date. Then, drag the fill handle (small square in the bottom-right corner of the cell) down to copy this formula for each subsequent row.

Note: This assumes you'll add a new row for each workday. If shifts span multiple days, you can alter this approach.

Formatting Time and Total Hours

2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel

Format the 'Check-in Time' and 'Check-out Time' columns as 'Time' for accurate tracking. For the 'Total Hours' column, enter this formula in the first cell below the headers: "=IFERROR((G2-H2)/24,0)". This calculates the total hours worked, assuming a 24-hour format. Copy this formula down to apply it to all rows.

IIf and Vlookup for Attendance Tracking

Next, we'll use the IF function and VLOOKUP to create a more comprehensive attendance tracker. In a new sheet named "AttendanceSummary", create the following headers: 'Employee Name', 'Total Hours This Week', 'Total Hours This Month', and 'Total Hours This Year'.

Easy Attendance Sheet Tutorial
Easy Attendance Sheet Tutorial

Populate the 'Employee Name' column with your list of employees. In the subsequent columns, use the following formulae:

Total Hours This Week

Fully Automatic Attendance sheet  With Salary sheet in excel by learning Center in Urdu/hindi
Fully Automatic Attendance sheet With Salary sheet in excel by learning Center in Urdu/hindi
Excel Employee Attendance Calendar Template
Excel Employee Attendance Calendar Template
Advance ATTENDANCE SHEET in Excel \
Advance ATTENDANCE SHEET in Excel \
attendance sheet with salary in excel format
attendance sheet with salary in excel format
Automate Attendance In Excel
Automate Attendance In Excel
Redirecting...
Redirecting...
an employee attendance sheet with the numbers and dates for each employee, including one in blue
an employee attendance sheet with the numbers and dates for each employee, including one in blue
How To Make attendance sheet for beginners excel
How To Make attendance sheet for beginners excel
How to Find Working Hours and Calculate Totals in Attendance Sheets – A
How to Find Working Hours and Calculate Totals in Attendance Sheets – A

In the 'Total Hours This Week' column, enter the following formula: "=SUMIF(Sheet1!$B:$B, A2, Sheet1!$E:$E)". This uses a SUMIF function to add up the total hours worked this week for each employee. Press Enter, then drag the formula down to apply it to all employees.

Total Hours This Month and This Year

Similarly, use VLOOKUP to extract total hours data for the month and the year. For 'Total Hours This Month', enter: "=VLOOKUP(A2, Sheet1!$A:$E, 5, FALSE)". This looks up the employee's name in the 'Date' and 'Employee Name' columns and retrieves the corresponding total hours for the current month. Do the same for 'Total Hours This Year' with the appropriate date range adjustment.

Regularly updating and reviewing these totals provides valuable insights into labor distribution and productivity.

By following this guide, you've created an automated daily labor attendance tracking system in Excel. This system ensures accurate records and simplifies daily operations management. As needed, you can further customize and expand this sheet to suit your specific business requirements."