Daily attendance sheet that calculates monthly percentage

Closed

Excel

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 Contributor 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!!

How to calculate daily attendance percentage
Monthly attendance percentage formula - Best answers
How to calculate monthly attendance percentage - 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 paisa to percentage - Office Software Forum
How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
How to calculate fuel surcharge - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

Help to convert a date to julian date fromat yyyyddd in excel

Formula in Excel to turn numbers into text

I want to send 120 e-mail with 120 attachments

Compare values in two columns and return the value from third

convert numbers to words in excel

How to stop today function date changing every day in Excel

Similar discussions

Subscribe To Our Newsletter!