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 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 compute percentage of attendance for the month
How to get percentage of attendance for the month - Best answers
How to calculate monthly attendance percentage in excel - Best answers
Percentage to paisa calculator - Office Software Forum
How to compute vat amount - Guide
How to send a message to all computers on a network - Guide
The two computers couldn't connect in the amount of time allotted ✓ - Network Forum
Percentage generator - Office Software Forum

1 response

Answer 1 / 1

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