Time Card Assignment
Introduction:
When you get your first job and others thereafter, keep a back up record of your weekly hours. Using Microsoft Excel create a time card to keep track of your hours and rate of pay
Directions:
Header Information and Setup:
1. Highlight cells A1:I1, click on the “Merge and Center” button.
2. Type in “Employee Timecard with Your Name” format = Arial 18, bold, center.
3. Cell A4: type “Employer Name:” format = Arial 10, bold, left aligned
4. Cell A5: type “Manager:” format = Arial 10, bold, left aligned.
5. Cell B4: type your first & last name, format = Arial 10, Bold, left.
6. Cell B5: type in your manager’s name (if you don't have one, make up a name), format = Arial 10, left.
7. Cell E4: type “Hourly Wages:” format = Arial 10, bold, left.
8. Cell E5: type “Overtime Wage:” format = Arial 10, bold, left.
9. Cell F4: type in overtime amount which is usually "time and one-half", if you do not have a job type “8.00” for hourly wages and $12.00 for overtime. = Arial 10, left. .
Table Information and Setup:
1. Highlight cells A7:I20. Format Cells – Border Outline Thick and Border Outline Inside thin black line.
2. Highlight Cells A7:I7. Format/Cells: Alignment – Merge Cells, Patterns – (New Shade + Pattern)
3. Cell A7: type “January” format = Arial 16, left
4. Highlight Cells A8:I8, Format/Cells: Patterns- Shading – Grey
5. Cell A8: type: “Week” format = Arial 12, bold, left
6. Cell B9:I15, font format = Arial 10, CENTER.
7. Cell B8, D8, F8, H8: type “Week 1” , “Week 2” , “Week 3” , “Week 4”
8. Cell C8, E8, G8, I8: type “Overtime”
9. Cells A9:A15, type each day of the week in as seen in example, format = Arial 10 left
10. Cell A16: type “Weekly Hours” format = Arial 10, bold, left align
11. Cell A17: type “Weekly Income” format = Arial 10, bold, left align.
12. Cell A18: type “Monthly Income Before Taxes” format = Arial 10, bold, left align.
13. Cell A19: type “After Taxes” format = Arial 10, bold, left align.
14. Cell A20: type “Total Income After Taxes” format = Arial 12, bold left.
15. Cells A20:I20 Format Cells: Patterns – Add shading and pattern
16. Cells A 20:I20 = Format/Row/Height 25
17. Cell B20 = Bold and Italicize, Font size 12
18. Cells A8:I8 – Format/row/Height/20
19. Cells A9:I19 = Format/Row/Height/15
20. Cells A1:I20 = Format/Column/AutoFit Selection.
Fill in your hours that you would work, and/or possibly over-time. Don't worry if you don't have a job, just put in pretend hours.
|
Formulas: |
|
1. Cell B16 – Formula: =SUM(B9:B15) |
|
2. Cell C16 – Formula: =SUM(C9:C15) |
|
3. Cell D16 – Formula: =SUM(D9:D15) |
|
4. Cell E16 – Formula: =SUM(E9:E15) |
|
5. Cell F16 – Formula: =SUM(F9:F15) |
|
6. Cell G16 – Formula: =SUM(G9:G15) |
|
7. Cell H16 – Formula: =SUM(H9:H15) |
|
8. Cell I16 – Formula: =SUM(I9:I15) |
|
9. Cell B17 – Formula: =SUM(B16*F4) |
|
10. Cell C17 – Formula: =SUM(C16*F5) |
|
11. Cell D17 – Formula: =SUM(D16*F4) |
|
12. Cell E17 – Formula: =SUM(E16*F5) |
|
13. Cell F17 – Formula: =SUM(F16*F4) |
|
14. Cell G17 – Formula: =SUM(G16*F5) |
|
15. Cell H17 – Formula: =SUM(H16*F4) |
|
16. Cell I17- Formula: =SUM(I16*F5) |
|
17. Cell B18- Formula: =SUM(B17:I17) |
|
18. 25. Cell B19- Formula: =SUM(B18*.25) |
|
19. 26. Cell B20- Formula: =SUM(B18-B19) |
21. File/Page Setup/Layout/Landscape
Created by Ryan Balcom, PHS Student 4/2007
Modified by Lynn Olps 4/2008
Assignment Courtesy of Ryan Balcom, Student at PHS – 2007
Modified 04_08