Daily attendance sheet that calculates monthly percentage
Closed
jazzygirl77
Posts
1
Registration date
Wednesday May 22, 2013
Status
Member
Last seen
May 22, 2013
-
May 22, 2013 at 01:28 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 27, 2013 at 09:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 27, 2013 at 09:59 AM
I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance percentage based on a 30-day month. Is there a way to import that information automatically from that month's previous sign-in sheets that shows current attendance percentage? Absences and tardys are counted the same. As long as they are signed in by 7:00, they are counted as present.
Thank you!!
Thank you!!
Related:
- How to calculate daily attendance percentage
- How to calculate monthly attendance percentage - Best answers
- How to calculate attendance percentage in excel - Best answers
- How to calculate percentage of marks of 6 subjects - Excel Forum
- How to calculate position in excel ✓ - Office Software Forum
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
- Calculation of positions in excel ✓ - Excel Forum
- Percentage formula in excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 27, 2013 at 09:59 AM
May 27, 2013 at 09:59 AM
Hi Jazzygirl,
I'm sure it's possible, but hard to give solution without some sample data. Is it possible to post workbook using sites like www.speedyshare.com or ge.tt?
Awaiting your reply,
Trowad
I'm sure it's possible, but hard to give solution without some sample data. Is it possible to post workbook using sites like www.speedyshare.com or ge.tt?
Awaiting your reply,
Trowad
