Upload your Excel file with columns: Emp Code, Name, Father's Name, Department, Designation, Date, In Time, Out Time, Working Hours, Total Hours, Att Type, etc.
Bikaji Foods International Limited
Muster Roll Sheet
Abbreviation Used
1. P - Present (DP)
2. ½ - Half Day (DP/ABS)
3. A - Absent (ABS)
4. L - Leave
5. H - Holiday
6. W - Weekly Holiday (WO)
7. PH - Festival Holiday
8. EL - Earn / Paid Leave (EL)
DW = P + 0.5 × ½
HLD = H + W
LEAVE = EL
PH = PH
ABS = A + 0.5 × ½
TOTAL = DW + HLD + LEAVE + PH