attendance

Hello everyone, Last night I asked a similar question and got an extremely helpful answer! But today, I have a different scenario. Would it be possible to double click on any cell within a range of cells (C2:C70, D2:D70, E2:E70, etc) that produces the following values and can cycle through...

Hey folks, I'm trying to come up with a yearly calendar (one that I can advance to the next year). The idea for the calendar is to have six sheets, each with about 40 people, and their attendance throughout the year. Ideally, you'd be able to look at one name at a time, that way I can show it...

Sheet 1: P=Presnt A=Absent <tbody> ID 1-Jan-17 2-Jan-17 3-Jan-17 4-Jan-17 5-Jan-17 6-Jan-17 7-Jan-17 8-Jan-17 9-Jan-17 10-Jan-17 001 P P A P A A A P P A 002 A P P P P A A P P P 003 A A A A A P P P P P 004 A P P P P P P P P P </tbody> Sheet 2: <tbody> 001 1-Jan-17 6-Jan-17...

Good afternoon, I ran a year-to date (YTD) attendance report on my team of 3000 employees. Those with more than 3 sick days within that period had verbal coaching. They are flagged thru conditional formatting whenever the number 3 comes up on the Sick column. Every week I ran a WTD report to...

I'm trying to create a workbook that tracks attendance. The main goal is to see how often a person has attended over a period of time based on the current date. I have come up blank on how to accomplish this. Could anyone provide any insight? The data would be in one worksheet as shown...

Hi guys, I have a question that has been on brain for the last couple of hours.... I am working on an attendance tracker and each month of the year has its own sheet in the same workbook. Then I have an overall sheet. On the overall sheet I would like a column for to find out how many points...

Hey guys! I am new to MrExcel and I have a confusing question for you all. I am working on an attendance tracker for work and we have a unique policy that for every 4 occurrences someone is late less then 25 minutes (tardy) they are given .5 a point towards their record I use "T" to identify...

Hi everyone, I am a staff of a small private training establishment, am producing an attendance sheet by using excel. I have 2 scenarios which I have been looking for formulas to sort them out, here is the story: In the attendance sheet, we have some markings for being late, half-day...

Hello, I have an attendance calendar that automatically tells the date of holidays based on the year in cell: G2. I need the holidays that fall on Saturday to show the date as the Friday before, and holidays that fall on Sunday to show the Monday after. Here is the equation I have for...

I am trying to make a register for my students. Along the top being the date and student down the side at the end i have present abcent and late. I am trying to populate a sum for the month end. The formula i have used is =COUNTIF(B3:F3,"p") All date cells selected and if p inserted then it...

i have a 2-page attendance book for the month i have found the macro in here about page 1-31 but the problem is when i try that it prints page1-31 page1-31 page2-31 page2-31 is there anyway i can make it print page1-62 page2-62 page3-63 page4-64... pls

Hello, We are having too many discrepancies with our point keeping system. I am looking for the best way to track employee points. Our point rules are: .5 points if late 1 point if absent I will enter the points on the spreadsheet. 10 points is termination. We have a formula that is...

I have an Excel-sheet on which to administer absence from a sports team. The cells in the sheet are filled with textual input (reason of absence and date of notification). The first row exists of dates (training sessions & matches), the first column exists of the player names. I want to create...

Hi, I have a team of 50 people and counting. I would like to create an automated attendance tracker wherein a user should be able to login / logout with command buttons. As soon as he opens the file, he should be a pop up message requiring him to login. The logoff button should be hidden until...

I'm trying to set up a check-solution system when my staff enter in the hourly attendance of our clients. The rounding system is a bit weird, so let me briefly explain it as best I can. Our regular hours are from 8:00am - 2:00pm. We charge per 15 minutes. A minute before 8:00am would be...

To start out, this page and its function as a whole, works. My issue, is on the 'Indiv. List' Tab, cell $A$4. I would like for this cell to show the Full Name of the employee, vs either First or Last name. On the 'Getting Data' Tab, I use this coding, to pull data from each corresponding...

Hi, I want to barcode scan time in & out of the employees (from an existing list) as and when they come & go. And at the end of the month want to calculate the total number of hours they have worked. I Will be issuing them with a card containing a unique id, their names with the barcode of the...

Hello there! I need some help on a formula I can enter on an Attendance/Score Spreadsheet. Here is what the sheet looks like: number__student name___START date___ month/day___ month/day___ month/day___ month/day____ m/d____ m/d____ m/d__ m/d___ m/d...

<tbody> A B C D E 3/31/2014 4/7/2014 4/14/2014 5/12/2014 Amy x Bill x x Tom x 4/2/2014 4/9/2014 4/16/2014 5/16/2014 Amy x </tbody> I'm trying to count missed attendance based on the person's name (column a) and a range of dates (rows 1 and 6) before...

<tbody> I am a martial arts instructor and I keep my attendance records in an Excel workbook. There is one worksheet for each of four schools, a Master and a Consolidated (as the students are allowed to train at more than one venue, so I need to have a record of their attendance at their...