Scribd
Upload
63 views5 pages

Attendance Report for Excel Assignment

The document contains attendance records for 30 students across 3 departments - Finance, Marketing, and HR. It tracks their attendance over 21 days from January 5th to May 29th, noting whether each student was present, absent, on leave or late each day. Total attendance numbers are calculated at the end.

Uploaded by

Khushboo Nagpal
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
63 views5 pages

Attendance Report for Excel Assignment

The document contains attendance records for 30 students across 3 departments - Finance, Marketing, and HR. It tracks their attendance over 21 days from January 5th to May 29th, noting whether each student was present, absent, on leave or late each day. Total attendance numbers are calculated at the end.

Uploaded by

Khushboo Nagpal
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

01/05/2020 04/05/2020 05/05/2020

Friday Monday Tuesday


S.R. No. Roll No Name Department
Topic
Hours
1 1920982501 A Finance Present Present Absent
2 1920982502 B Finance absent Present present
3 1920982503 C Finance Present Present present
4 1920982504 D Finance absent Present late
5 1920982505 E Finance
6 1920982506 F Finance
7 1920982507 G Finance
8 1920982508 H Finance
9 1920982509 I Finance
10 1920982510 J Finance
11 1920982511 A Marketing
12 1920982512 B Marketing
13 1920982513 C Marketing
14 1920982514 D Marketing
15 1920982515 E Marketing
16 1920982516 F Marketing
17 1920982517 G Marketing
18 1920982518 H Marketing
19 1920982519 A H.R
20 1920982520 B H.R
21 1920982521 C H.R
22 1920982522 D H.R
23 1920982523 E H.R
24 1920982524 F H.R
25 1920982525 G H.R
26 1920982526 A SCM
27 1920982527 B SCM
28 1920982528 C SCM
29 1920982529 D SCM
30 1920982530 E SCM
06/05/2020 07/05/2020 08/05/2020 11/05/2020 12/05/2020 13/05/2020 14/05/2020
Wednesday Thursday Friday Monday Tuesday Wednesday Thursday

Present Present Absent Present Leave Present Present


Present absent present Present present leave leave
Present Present present Present present Present Present
late late late Present present Present absent
15/05/2020 18/05/2020 19/05/2020 20/05/2020 21/05/2020 22/05/2020 25/05/2020
Friday Monday Tuesday Wednesday Thursday Friday Monday

Late Absent Present Leave Present present Leave


late present Present present Present present Leave
present present Present present Present present present
Late leave late present Present present Leave
26/05/2020 27/05/2020 28/05/2020 29/05/2020
Tuesday Wednesday Thursday Friday
Total Present Total Absent

Present present present present 14 3


absent present absent Present 13 4
Present present present Present 21 0
late leave Absent Present 8 3
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
Total Leave Total Late Total Days Percentage of Attendence

3 1 21 67%
3 1 21 62%
0 0 21 100%
3 7 21 38%
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!
0 0 0 #DIV/0!

You might also like