Need Help with Dynamic Attendance Report

xcruc1at3r

Board Regular
Joined
Aug 4, 2011
Messages
50
I need a Attendance Dashboard that reflects the data of people based on their Total Lates
Highest Lates, lates above the given criteria such as 8:30 and above then 9:00 and above then 9:30 and above
and a block where we can search by ID number or name to see the statistics of Administration and Domestic
and Top Three people which Most lates
Can add New Employee as well
and lates at 15:00 hours and above
Attendance Board for management in different block and domestic in different block but on the same page and

I have a Deadline Monday Max 5th of Nov i have uploaded the file as well

EDIT: removed contact information - Moderator
 
Last edited by a moderator:

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,129,754
Messages
5,638,170
Members
417,011
Latest member
Amaden95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top