Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Attendance Tracker

Hi,

I have attached a sample tracker - where i have 2 tabs one is attendance tracker and another one is production tracker.

Now i am looking out for a formula which counts attendance based on there production numbers for that respective day.

Here is what is am looking:

If an employee has done production more than "0" than his attendance should reflect as "Present".

If an employee has done production less than or equal to "0", than his attendance should reflect as "Absent".

Can anyone please help me out to solve this.


Post your answer or comment

comments powered by Disqus
I need Help! The only way I can think to do this is create a separate
worksheet for each employee which we will interact with on a daily basis.
I'm struggling because I want to have a worksheet that collects all of the
data from each employees worksheet and puts it all together in one view. I
would love some suggestions on how to do it or on how I should design this
Attendance Tracker. FYI there are about 550 employees.

Hi everyone,

I have been tasked with coming up with an attendance tracker at work. I have been messing with it for a while now and I have been surfing the web for answers. I have found a lot of things that are similar, but I can't quite adapt them to what I want to do.

So, we award 1/3 of a point for a tardy and 1 point for an absence.

The Tardy/Absence criteria will pull from another spreadsheet.

I used a countif to determine the number of points based on Tardy/Absent.

I am now trying to create a rolling 90 day total and a rolling 365 day total. So I will pull up the file, add a new column that will pull the previous day's Absences/Tardies and then have my 90/365 day period update to reflect the new date.

I have been messing around with OFFSET and EDATE, which are new to me. If anyone can help me come up with a formula to figure this out, I would be ecstatic! It would be even better if you could explain how it was done as well so I can learn. Thanks!

~B

Good Morning All,

Im very new to the VBA coding & Macros, I need a favour from You hope i will get help

I have an Excel sheet named as Attendance Tracker in which i maintain attendance of employees.

Now my seniors are asking me to automate the same & their requirements are -
we will create seperate sheets for all the team leadersEach team lead should access only their team sheet and should not have access to other sheetsWe should have consolidated sheet where in all team leads data has to be consolidated.consolidated sheet should be accessible only from managers.

Please help me regarding this.

Thanks & Regards
Tanveer

I am trying to do an attendance tracker for about 900 people. These people will be divided into 30 people to 30 rooms. Column A will be a dropdown menu with the room numbers and column B will then return the list of people in that room. I would then like Column C to have a drop down menu with Absent/Present/Late/Excused options.

Does this require a macro or can it be done with data validation. If anyone could steer me in the right direction I would appreciate it.

I have attached here an attendance tracker that I maintain.

Now using Pivot Table I want to pull data in regards to information for each employee. I need to know the no of leaves he has taken in a particular month as well as on a total basis.
Also I need to know how many morning/afternoon shifts they worked in a month as well as on a total basis.

Please help if possible.

I have an attendance tracker which has month on month data in various spreadsheets and I have included a spreadsheet named " Summary " , which should basically give me the sum of the leaves for each employee ( pulled from various sheets ) . Please help me .. Thank you

Hi in the attached file i have prepared the format of employee attendace tracker. In the first sheet(leave details) i wanted to know how many leave for each employee is pending for the whole year, i have put the COUNTIF formula in cell E4 but it gives me error message "circula cell referen

=COUNTIF(January!E4:AI4,"ML").=COUNTIF(January!E4:AI4,"ML")but this formula is only caluculating only for january and i wanted to calculate for whole year.Leave details are on first sheet Shows number of maximum number of days an employee can take what leave. I am attached the file i prepared please let me know where i am making mistake. Thanks in advance.

Dear Experts,

Please Find the attachment.
and please give solution for monthly employee attendance current day present, training & invoice auto updating...
waiting for replay... Thanks

Regards,

Sanjeevi

Hi all,

I am creating a attendance tracker. I need your help for the completion.

I am looking for a control which can track the changes. To be more specific, If a person updates the data in the sheet once, it should be locked. The next time, he/she should not be able to update it. It should be possible only with a controller who can in turn give a password and then make the necessary changes. I am not using any macros and it runs only on formulas. Please help me in this for the completion. I am already breaking my head for this.

Your help is appreciated,
Thanks in advance,
Praveen

I'm looking for a template for attendance record keeping for each employee.

hi all,,

I had a worksheet in which i track the attendance of my employees.Please tell me how would i Keep track of the following;

1. When ever a month is selected in the Cell A3, The days & the dates corresponding to that Month & Year should be displayed in the columns as shown in the worksheet.

2.I want to Disable the cells which had SUNDAYS in the DAYS Column. I mean the Column SUN should not be allowed for entering data.

3.How to Calculate the no.of Days an employee worked if he/she works for Half-a-day.

Please help me in solving this.

Hi,

I want to prepare a attendance tracker for March 08. Following are the points i want to include in that tracker

1) I will be having data of around 60 Employees which are divided in 4 Teams(approx 15 in 1 team). i want weekly attendance percentage of each and every single Employee as well as the weekly attendance percentage of 4 teams also. the attendance will be inputed by me everyday.

2)i will marked the present employees as "P" and Absent employees as "A". so which calculating the weekly % this criteria must be kept in mind.

Please help me in this problem. i have attached an Excel sheet of what i exactly want.

Thanks a ton.

I am trying to create an attendance tracker that will allow me to select a choice from a drop-down that corrensponds to the call-off reasoning. Each day of the month will have a Data Validation drop-down that includes 3 categories and time increments for each. PTO and UPTO will have times that need to be totaled month to date according to total time entered. Tardy will need to be totaled monthly with actual occurences (not total time.)

PTO/UPTO= 2.5+1+3=6.5 (6.5 being the total for the month)
Tardy - .75+.5+.25=3 total occurences.

I have included the sheet (because I probably didn't explain well...)

Thank you in advance for any and all help!!!

Hi,

I am using the following code to create a custom command menu.


	VB:
	
 AddMenus() 
    Dim cMenu1 As CommandBarControl 
    Dim cbMainMenuBar As CommandBar 
    Dim iHelpMenu As Integer 
    Dim cbcCustomMenu As CommandBarControl 
     
     '****************************************************************
     'Delete exisiting toolbar
     '****************************************************************
     
    On Error Resume Next 
    Application.CommandBars("Worksheet Menu Bar").Controls("&New Menu").Delete 
    On Error Goto 0 
     
     '****************************************************************
     'Set a command variable to worksheet menu bar
     '****************************************************************
     
    Set cbMainMenuBar = Application.CommandBars("Worksheet Menu Bar") 
     
     '****************************************************************
     'Return the Index number of the Help menu. We can then use this
     'to place a custom menu before.
     '****************************************************************
     
    iHelpMenu = cbMainMenuBar.Controls("Help").Index 
     
     '****************************************************************
     'Add a Control to the "Worksheet Menu Bar" before Help.
     'Set a CommandBarControl variable to it.
     '****************************************************************
     
    Set cbcCustomMenu = cbMainMenuBar.Controls.Add(Type:=msoControlPopup, _ 
    Before:=iHelpMenu) 
     
     '****************************************************************
     'Give the control a caption
     '****************************************************************
     
    cbcCustomMenu.Caption = "&Logistics Attendance Tracker" 
     
     '****************************************************************
     'Add another sub control and give it a Caption and tell it which
     'macro to run
     '****************************************************************
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Open Net 2 Access" 
        .FaceId = 33 
        .OnAction = "Open_Net2" 
    End With 
     
     '****************************************************************
     'Add a sub control and give it a Caption and tell it which macro
     'to run.
     '****************************************************************
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Add New Employee" 
        .FaceId = 607 
        .BeginGroup = True 
        .OnAction = "Run_Addrecord" 
    End With 
     
     '****************************************************************
     'Add another sub control and give it a Caption and tell it which
     'macro to run
     '****************************************************************
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Edit / View Employee" 
        .FaceId = 607 
        .OnAction = "Run_viewrecord" 
    End With 
     
     '****************************************************************
     'Add another sub control and give it a Caption and tell it which
     'macro to run
     '****************************************************************
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Delete Employee" 
        .FaceId = 607 
        .OnAction = "Run_deleterecord" 
    End With 
     
     
     '****************************************************************
     'Add another menu that will lead off to another menu
     'Set a CommandBarControl variable to it
     '****************************************************************
     
    Set cbcCustomMenu = cbcCustomMenu.Controls.Add(Type:=msoControlPopup) 
     
    cbcCustomMenu.Caption = "Holidays" 
     
     
     '****************************************************************
     'Add a control to the sub menu, just created above
     '****************************************************************
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Add Employee Holiday" 
        .FaceId = 126 
        .OnAction = "Run_addholiday" 
    End With 
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Edit Employee Holiday" 
        .FaceId = 126 
         
    End With 
     
    With cbcCustomMenu.Controls.Add(Type:=msoControlButton) 
        .Caption = "Delete Employee Holiday" 
        .FaceId = 126 
         
    End With 
     
     
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I want to add a new button control at the bottom of the menu underneath the holiday control but it keeps adding it on the sub menu, which leads off the holiday button control.

I want the menu to look like this.

Open Net 2 Access
Add Employee
Edit Employee
Delete Employee
Holidays (3 options on sub menu)
*New Control

Thanks,

Hey All,

Does anyone know a way around the 1,208 control limitation? Whenever I add more then 1,208 controls to my one sheet all of the worksheet_change code automatically turns off (1,207 controls the code works fine.) Some of you may ask why I have 1,208 controls...well I am using excel as an attendance tracker for 1000 employees. Each employee has two radio buttons associated to them (attended training yes and attended training no.) Those controls are linked to some other cells and have some formulas calculating off of them. Anyone have any thoughts or suggestions?

And yes I know using this many controls is not ideal for excel but unfortunetly I don't have any other programs as options.

Thanks

Hello all,

I have created an attendance tracker for a team of people at work. It simply involves a grid of the days of the month and on each 'day' (or cell) I have set up the Validation command to prompt the the user to select whether they were at work, on holiday, off sick etc. etc from a drop down box. If they do not change the cell, its defaulted value is that they are in work.

When a user selects the days that they are planning a holiday in the future, they are meant to write a comment on the cells they have changed, to advise when they had 'requested' the holiday.

What I would like is (a macro?) which makes the comment box automatically 'pop up' when they change a cell from its default value prompting them to fill in the details rather than relying on them to 'add comments' manually.

In addition, what would be the best way to 'restrict' them from booking holiday within the next 7 days - we have a problem with people booking holiday on 'lastminute.com' for 2 days time, booking off the holiday on the spreadsheet and saying that they had it planned for weeks!

I am hoping the comments box would help, but having the inability to book holiday for within the next two weeks would be ideal.

Many thanks fior any input you can offer. The automatic pop-up of the comments box would be a great start!

Kind regards,

James
UK

I have downloaded this template. How do I go about adding employees?

Merry Christmas Everyone!!

I've posted this on another board - got lots of views but no responses
so I'm hoping Santa will be good to me and someone reading this thread
will have an answer.

We have 100+ employees. We need to track PTO, Vacation in hours and
then also log other instances of time away from work (f= fmla,
t=travel, c=comp time, h=work at home). However these "other
instances" do not need to be tracked in terms of hours used.

The only suggestion that came on the other board was to have 3 rows per
employee - not a good solution.

My solution so far has been to have 3 columns for each day but this is
causing me to run out of columns before I get to April.

I thought I could use SUMIF but apparently I'm wrong. Why can't I put
something like "8v" (indicating 8 hours of vacation used) and then have
my totals column look at the range and sum if it says 8v, the column
next to this would sum if it said 8p.

Any help would be appreciated.

--
Donna123
------------------------------------------------------------------------
Donna123's Profile: http://www.excelforum.com/member.php...o&userid=26962
View this thread: http://www.excelforum.com/showthread...hreadid=495940

I am using a great Excel template posted on the MS Website. The first tab
(meant for a single employee) is a calendar for 2009 and you can code what
kind of absences that employee has thorughout the year. The worksheet totals at the bottom and it also links to another Summary tab.

The problem is that There is only ONE employee tab in the template. Is
there a way to add a tab for each employee and efficiently update the Summary tab? of do I have to hardkey a tab and cell number in each cell in the summary page?

I am using a Excel 2009 spreadsheet converted to my 2003 Excel. The
template on the microsoft site is called "2009 Employee Attendance Tracker"

Thanks

Hi all,

I am creating a attendance tracker. I need your help for the completion.

I am looking for a control which can track the changes. To be more specific, If a person updates the data in the sheet once, it should be locked. The next time, he/she should not be able to update it. It should be possible only with a controller who can in turn give a password and then make the necessary changes. I am not using any macros and it runs only on formulas. Please help me in this for the completion. I am already breaking my head for this.

Your help is appreciated,
Thanks in advance,
Praveen

I am working on an attendance tracker and we need to provide the names of specific types of absences from the data entry fields on demand. what we have is like this
A B C
1 Agent name Reason Shift
2 Agent 1 Tardy 0700-1530
3 Agent 2 NCNS 0700-1530
4 Agent 3 Sick 0800-1630
5 Agent 5 NCNS 0800-1630

What I need is to be able to have a result such as...

NCNS
Agent 2
Agent 5

Tardy
Agent 1

Of course we are doing it by hand now, but is there a way to get this to do it for us?

I'm creating an attendance tracker based and I want to populate the cells in the Calendar tab with data from the Log tab.

Basically, in each cell, I want to return the code that matches both the date and the employee's name, if an entry for that employee on that date exists at all.

Sorry if I didn't explain very well - I've been fighting with Excel for 2 days and am not clear-minded at all when it comes to functions right now.

Hello, (this is my 1st post and I tried to follow the rules!)
I need a formula(s) to use in an attendance tracking document that will count new people only each session, and keep a running total. I have to do this in terms of number of people, race, and age. Any suggestions? Thanks,
Melanie

I attached sample attendance tracker document for reference.

Merry Christmas Everyone!!

I've posted this on another board - got lots of views but no responses so I'm hoping Santa will be good to me and someone reading this thread will have an answer.

We have 100+ employees. We need to track PTO, Vacation in hours and then also log other instances of time away from work (f= fmla, t=travel, c=comp time, h=work at home). However these "other instances" do not need to be tracked in terms of hours used.

The only suggestion that came on the other board was to have 3 rows per employee - not a good solution.

My solution so far has been to have 3 columns for each day but this is causing me to run out of columns before I get to April.

I thought I could use SUMIF but apparently I'm wrong. Why can't I put something like "8v" (indicating 8 hours of vacation used) and then have my totals column look at the range and sum if it says 8v, the column next to this would sum if it said 8p.

Any help would be appreciated.


No luck finding an answer? You could always try Google.