0% found this document useful (0 votes)
47 views5 pages

March 2024 Employee Attendance Record

Excel Attendance sheet

Uploaded by

shoryacomputer40
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
47 views5 pages

March 2024 Employee Attendance Record

Excel Attendance sheet

Uploaded by

shoryacomputer40
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Attendance sheet Months MAR First Date Friday, March 1, 2024 Last Date

Date 1-Mar 2-Mar 3-Mar 4-Mar 5-Mar


Name of
Sr No. Employee Designation Days Fri Sat Sun Mon Tue
1 P A P P
2 P A A P
3 P A A P
4 P PP A P
5 P PP A P
6 A PP P A
7 A H P A
8 A H PP A
9 A H PP A
10 H H PP H
11 H H PP H
12 H H PP H
13
Sunday, March 31, 2024
6-Mar 7-Mar 8-Mar 9-Mar 10-Mar 11-Mar 12-Mar 13-Mar 14-Mar 15-Mar

Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri
A PP P P A PP P P A PP
A PP A P A PP A P A PP
A PP A P A PP A P A PP
PP PH A P PP PH A P PP PH
PP PH A P PP PH A P PP PH
PP P P A PP P P A PP P
H P P A H P P A H P
H P PP A H P PP A H P
H P PP A H P PP A H P
H P PP H H P PP H H P
H P PP H H P PP H H P
H P PP H H P PP H H P
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar 21-Mar 22-Mar 23-Mar 24-Mar 25-Mar

Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon
P A PP P P A PP P
A A PP A P A PP P
A A PP A P A PP P
A PP PH A P PP PH P
A PP PH A P PP PH P
P PP P P A PP P A
P H P P A H P A
PP H P PP A H P A
PP H P PP A H P A
PP H P PP H H P H
PP H P PP H H P H
PP H P PP H H P H
26-Mar 27-Mar 28-Mar 29-Mar 30-Mar 31-Mar
Present Absent Double
Tue Wed Thu Fri Sat Sun Days Days Half Duty Duty
A PP P ph PP 12 7 0 14
A PP A P PP 7 13 0 14
A PP A P PP 7 13 0 14
PP PH A P PP 7 6 0 16
PP PH A P PP 7 6 0 16
PP P P A a 12 8 0 14
H P P A a 12 8 3.5 0
H P PP A a 6 8 3.5 12
H P PP A a 6 8 3.5 12
H P PP H h 6 0 7.5 12
H P PP H h 6 0 7.5 12
H P PP H h 6 0 7.5 12
Present + Company Total Salary Total E.P.F E.S.I
Half off Days Salary Per Day salary @12% @1.75% Pay Salary
1.5 4 31.5 5000 166.667 5250 630 91.875 4528.125
0 4 25 6000 200 5000 600 87.5 4312.5
0 4 25 7000 233.333 5833.333 700 102.083 5031.25
9 4 36 8000 266.667 9600 1152 168 8280
9 4 36 9000 300 10800 1296 189 9315
0 4 30 10000 333.333 10000 1200 175 8625
0 4 19.5 11000 366.667 7150 858 125.125 6166.875
0 4 25.5 12000 400 10200 1224 178.5 8797.5
0 4 25.5 13000 433.333 11050 1326 193.375 9530.625
0 4 29.5 14000 466.667 13766.67 1652 240.917 11873.75
0 4 29.5 15000 500 14750 1770 258.125 12721.875
0 4 29.5 16000 533.333 15733.33 1888 275.333 13570

You might also like