Previous Topic Next Topic

Daily attendance sheet that calculates monthly percentage

Closed
jazzygirl77 Posts 1 Registration date Wednesday 22 May 2013 Status Member Last seen 22 May 2013 - 22 May 2013 à 13:28
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2013 à 09:59
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!!
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 May 2013 à 09:59
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

Similar discussions

Help to convert a date to julian date fromat yyyyddd in excel
seekermay -
Calixte DORVIL -

6 responses
Formula in Excel to turn numbers into text
ashwin12289 -
venkatesan -

4 responses
I want to send 120 e-mail with 120 attachments
issahamameh -
medo42002 -

35 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
convert numbers to words in excel
bharat456 -
venkat1926 -

1 response
How to stop today function date changing every day in Excel
Haneen H -
Klaas86 -

9 responses