Hello i am needing some help with creating a worksheet that is able to track attendance and display the most recent number of consecutive days absent.
It would have two sheets, one that would display a list of names and then next to them display number of hours missed and most recent consecutive days missed. The second would have dates along the top of the sheet and then the persons name and whether or not they were there at the beginning and end of the day in question.
The second sheet would be filled out everyday as to whether people had attended or not during role call.
Here is an idea of what i am looking for.
sheet 1.png
sheet 2.png
Sheet 1 would automatically update any time changes would be made to sheet 2 so if all five people were marked as being here both at the beginning and end of the next day (2/26/2014) sheet 1 would say that none of the hours had changed but all of the consecutive days would reset to 0.
I'm not sure on how to do this or if it is even possible to do in excel, my experience is limited to very basic functions so any help would be appreciated. if you need any more information for this let me know I have been struggling with this for weeks now.
Bookmarks