How to make Half Day attendance | how to count Dual Shift Attendance Automated Attendance बनाना सीखे
आप Excel में एक ऐसी Attendance Sheet बनाना सीखेंगे जो पूरी तरह से Automated होगी। इसमें आप A Shift, B Shift, Paid Holiday (PH), Half Day, और Dual Shift को एक ही Column में Count कर सकते हैं। Conditional Formatting, COUNTIF Formula, और Dropdown Lists का इस्तेमाल करके Attendance Management आसान बनाएं। यह Video आपके Time और Effort दोनों को बचाएगा।
Excel Tricks और Tutorials के लिए हमारे Channel को Subscribe करें!
How to make Half Day attendance | how to count Dual Shift Attendance Automated Attendance बनाना सीखे
⏱ **Video Chapters:**
0:10 Introduction
0:11 Attendance Sheet Intro
0:40 Attendance Key Points Assigned (0:40 - 2:19)
2:20 Formula Making Explanation (2:20 - 7:59)
8:00 Checking for Automatic Count (8:00 - 9:54)
9:55 Last Intro and Conclusion (9:55 - 10:03)
Topics Covered:
Excel Attendance Sheet Setup
Shift Codes Assign करना
Attendance Count Automation
COUNTIF और Conditional Formatting का इस्तेमाल
Shift wise attendance
A-shift B-shift C-shift D-Shift, double Shift, Half Day, PH payable Holiday count in one column with countif formula
📌 Tools Used:
Excel 2016/2019/Office 365
⏱ Video Duration: 10:03
Subscribe for more tips
Viral Tags:
#ExcelTutorial
#AttendanceSheet
#ExcelTips
#ExcelForBeginners
#OfficeTips
#AutomatedAttendance
#ShiftManagement
#ExcelFormula
#WorkFromHomeTools
#DataAutomation
Keywords for Tags:
Excel attendance sheet tutorial
Attendance sheet in Excel
How to count shifts in Excel
Automated attendance tracking in Excel
Excel COUNTIF formula for beginners
Excel sheet for staff management
Shift-wise attendance in Excel
Excel tricks for office use
Conditional formatting in Excel tutorial
Excel for time-saving tips