Simple Time card

[loriandrick]

Please Help!!

I am trying to create a simple timecard for my shop.

What I want to do is select my name from a drop down box or similiar and then select the week , and when they are selected, my timecard info will appear below for that week that was selected.

When I do select another week or names, i want their times to stay with their week.

I am confused on how to start this. I have downloaded alot of examples but they all contain start time and end times, when all i want is only total hours each day. Example; On monday I worked 8 hours regular and 2 hours OT.

Thanks for any help all of yee give me.

 

[daniels012]

If you keep all your records of data all on one sheet you could set up a second sheet that you filter the data to show just the data you want. Or in help files, read about Filter... Then Advanced Filter. I used to use this for a Product Order Form to list out just the items ordered last month, or All purchases over 150.00, etc.

Hope this helps,
Michael

 

[loriandrick]

Here is a part sample of the card i have.

My Time Card.xls
	E	F	G	H	I	J	K	L	M
4		Date Range	April 18, 2004			to	April 24, 2004
5
6		Sunday				Monday
7		Reg.	O.T.	Capital	Cap.OT	Reg.	O.T.	Capital	Cap.OT
8	Gerry S.					7.00		1.00
9	Rick G.							8.00	8.50
10	Calvin P.					8.00
11	Jim B.					0.50		7.50	0.50
12	Paul M.					4.00
13	Sub Total Per Day					19.50		16.50	9.00
14	Total Hours Per Day					45.00
April 18 - 24

I want to be able to select a certain date range and only that weekly time card will appear for the week that i select. This is where i can enter hours. At this moment i have many sheets on the bottom of the workbook. One for each week. I currently have about 60 sheets on the bottom.