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 Moderator Last seen January 16, 2023 - 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 monthly attendance percentage in excel
How to calculate position in excel ✓ - Office Software Forum
How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
How to calculate 90 days from date in excel - Guide
Calculation of positions in excel ✓ - Excel Forum
Formulas for 1st and 2nd position in class - Office Software Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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!