Spreadsheet: 33146d1229440237-using-a-drop-down-list-to-populate-a-different-cell-time-sheet-2009
Sheet: Time

Name: |  |  |  |  |  | SS#: |  |  |  |  |  |  | Employee ID:
Site: |  |  |  |  |  | CC#: |  |  |  |  |  |  | Period End Date: |  |  |  | 2009-01-04 00:00:00
Date |  | 2008-12-22 00:00:00 | 2008-12-23 00:00:00 | 2008-12-24 00:00:00 | 2008-12-25 00:00:00 | 2008-12-26 00:00:00 | 2008-12-27 00:00:00 | 2008-12-28 00:00:00 | 2008-12-29 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | Total
Day |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S
Reg. Schedule
Overtime Hours | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 1½ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Shift Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Afternoon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Midnight
Lost Time Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Floating Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Vacation
Lost Time Code
Lost Time Codes |  |  |  |  |  |  |  |  | This card is used to calculate your pay
1-Uexcused (no pay)                                          5-Excused sick (full pay) |  |  |  |  |  |  |  |  | Remarks
2-Excused personal bus. (no pay)               6 -Jury duty, funeral, military
3-Excused personal bus. (full pay)              7 -Vacation (full pay) |  |  |  |  |  |  |  |  | Salaried Time Report- BASF Corporation
4-Sick (60%)                                                         8 -Floating Holiday
Salaried Time Report
Instructions for Exempt/non-exempt Employees |  |  |  |  |  |  |  |  |  |  |  |  |  | Begin Date |  | End Date
1.  This time card form can be found on the HRLink under |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-12-22 00:00:00 |  | 2009-01-04 00:00:00
Company HR Forms. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-05 00:00:00 |  | 2009-01-18 00:00:00
2.  [NAME] name, SS#, Site, Cost Center and Period End Date (select |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00 |  | 2009-02-01 00:00:00
the appropriate period end date.  Please print clearly. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-02 00:00:00 |  | 2009-02-15 00:00:00
3.  For Non-exempt employees, post actual IN and OUT time daily |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-16 00:00:00 |  | 2009-03-01 00:00:00
4. For Exempt employees, only send in time sheet when recording |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-02 00:00:00 |  | 2009-03-15 00:00:00
lost time. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-16 00:00:00 |  | 2009-03-29 00:00:00
5.  Please copy this completed time sheet for your records before |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-30 00:00:00 |  | 2009-04-12 00:00:00
sending to [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-13 00:00:00 |  | 2009-04-26 00:00:00
6.  Time sheets are due to payroll the 3rd day after payday. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-27 00:00:00 |  | 2009-05-10 00:00:00
Date | Day | AM |  | PM |  | Overtime |  |  |  | Total hours |  |  |  | 2009-05-11 00:00:00 |  | 2009-05-24 00:00:00
 |  | In | Out | In | Out | In am/pm |  | Out am/pm |  |  |  |  |  | 2009-05-25 00:00:00 |  | 2009-06-07 00:00:00
2008-12-22 00:00:00 | M |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-08 00:00:00 |  | 2009-06-21 00:00:00
2008-12-23 00:00:00 | T |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-22 00:00:00 |  | 2009-07-05 00:00:00
2008-12-24 00:00:00 | W |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-06 00:00:00 |  | 2009-07-19 00:00:00
2008-12-25 00:00:00 | T |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-20 00:00:00 |  | 2009-08-02 00:00:00
2008-12-26 00:00:00 | F |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-03 00:00:00 |  | 2009-08-16 00:00:00
2008-12-27 00:00:00 | S |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-17 00:00:00 |  | 2009-08-30 00:00:00
2008-12-28 00:00:00 | S |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-31 00:00:00 |  | 2009-09-13 00:00:00
2008-12-29 00:00:00 | M |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-14 00:00:00 |  | 2009-09-27 00:00:00
2008-12-30 00:00:00 | T |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-28 00:00:00 |  | 2009-10-11 00:00:00
2008-12-31 00:00:00 | W |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-12 00:00:00 |  | 2009-10-25 00:00:00
2009-01-01 00:00:00 | T |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-26 00:00:00 |  | 2009-11-08 00:00:00
2009-01-02 00:00:00 | F |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-09 00:00:00 |  | 2009-11-22 00:00:00
2009-01-03 00:00:00 | S |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-23 00:00:00 |  | 2009-12-06 00:00:00
2009-01-04 00:00:00 | S |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 |  | 2009-12-20 00:00:00
Total hours |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
The hours reported are correct for the period indicted
Employee signature
Supervisor signature