Hello all,
The company I work for has been going through this transition and they are asking all employees to fill out time cards, and manually track their punches. Prior to this, office employees did not track their time and we had time clocks to capture punches. I came up with this spreadsheet for myself and they've adapted it for all office employees to use for the time being.
I was wondering if there was a better way to capture this information, preferably with formulas as a lot of the people using this are not very good with excel/computers in general. I've attached a copy of my form. I did blank out some information that could be considered confidential in the Category tab.
So how this works is, I record my punches on the left, in the grey boxes. To the right of each days grey box, there are columns to enter the amount of time you spent and what category/code that time falls under. The description box is for personal use and does not have to be filled out.
For codes I have the general work codes for vacation, sick, break, holiday, etc. The categories are a bit different. There are 6 different categories you can pick (A-I below each category are just examples of tasks that fall into that category and have no bearing on the form).
The blue boxes on the right will automatically pull numbers for each of the codes I have listed and total them.
My supervisor has informed me that we will also be using project codes... for example, I entered project "302" under a few days in this example form. Does anyone know if there is an easier way to automatically capture this information and pull it into the blue boxes? I could add "302" to the list but then when project 303 comes along I will also need to add that... I thought of just adding a spot to manually enter times but that seemed to be really confusing and disliked by the people I showed it to.
Does anyone have an suggestions? My supervisor told me she would like me to keep the design the same, so not to confuse people. She also prints these off each week for a record so I can't really keep adding to my list of codes.. or they won't fit on one page.
Bookmarks