Is this even possible

redpipe67

Board Regular
Joined
Aug 7, 2002
Messages
65
Good day all,
I am trying to create an excel file to track employee hours, overtime hours, early outs etc. The way I would like this to work would be for me to select the day and the people working that day and I would input their hours in the relevant boxes. This information would then be put automatically onto another sheet containing all this information from every day so I can get totals for weeks and months easily. On the main page once I have selected the next days date, I would like the figures and attendants I input from the previous day to dissappear and I would input the new staff members and their hours for the new day, etc. I would included the beginnings of the file i have started working on but I don't see how, and would like to ask if anyone can direct me to acheiving my goal. Thanks so much for any assistance. I can e-mail it to anyone if they would like to offer to help.

Andy
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
HINT: Create a database type table with your info. NOW, all your information can be easily retrieved in any format you choose using a PIVOT TABLE!! (It's called grouping)

Just a thought

lenze
 

redpipe67

Board Regular
Joined
Aug 7, 2002
Messages
65
I was going to attempt that but the only information that is in it is the Employee names and days of the year, everything else will be input as the days occur and from there will need to be added to the daily growing database, hours worked for each employee etc. If i have replied with a strange answer, I must not understand your reply correctly. Basically Im after 1 form with a drop down list of each day of the year (achieved) and a drop down list for each work spot containing each employee name (achieved), now I want to select a day, lets say Jan 1st 2006, and employee Anne, now in her hours worked cell I will input 8 for the amount of hours worked, now on the same sheet when i select Jan 2nd 2006 from the drop down list, i need to re-select an employees name, lets say Joe and he worked 5 hours and enter the hours worked for that day. Now if i reselect Jan 1st from the drop down list, anne will reappear with her 8 hours, now if I put Anne down for 3 hours on the 3rd I can pull up a seperate sheet for each employee and for anne I will have each day worked and the amount of hours on each day and a total at the bottom. My problem is this, if the cell I use to input the hour figure changes depending on the day and the employee, it can't be referencing anything as I am inputting a figure for the amount of hours into that cell. Is it possible to do this on 1 form or do I need to have a form for each day of the year?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,139
Office Version
365
Platform
Windows
Do you have Microsoft Access? Access comes with some Time & Billing Templates (see Andrew's response here: http://www.mrexcel.com/board2/viewtopic.php?t=180805).

I have never used it myself, but it might be worth checking out, as it might save you some time and effort.
 

Forum statistics

Threads
1,078,082
Messages
5,338,077
Members
399,203
Latest member
AskingForAFriend

Some videos you may like

This Week's Hot Topics

Top