Spreadsheet: 116483d1311863281-macro-to-change-sheet-name-within-a-formula-time-cards-group_example
Sheet: 07.29.11

07.29.11 |  |  | Date |  |  |  |  |  |  | Date |  |  |  |  |  |  | Date |  |  |  |  |  |  | Date |  |  |  |  |  |  | Date |  |  |  |  |  | 1 | Weekly Totals
Name |  |  | Regular Hours | OT Hours | Totals Up-To-Date | Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume |  | Regular Hours | OT Hours | Totals Up-To-Date | Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume |  | Regular Hours | OT Hours | Totals Up-To-Date | Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume |  | Regular Hours | OT Hours | Prorated Hours | Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume |  | Regular Hours | OT Hours | Totals Up-To-Date | Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume |  | Kronos Regular Hours | [NAME]  OT Hours | [NAME] Weekly Total | Prorated Hours | Project Hours | Prorated Project Hours | Actual Time Spent in IV | Hours to Remove Based on Volume | Hours to Apply to Metrics |  |  | Mon. Minus [NAME] | [NAME]. Minus [NAME] | Wed. Minus Lunch | Thurs. Minus [NAME] | Frid. Minus [NAME] |  | Mon. Project Time | [NAME]. Project Time | Wed. Project Time | Thurs. Project Time | Fri. Project Time
Name1 |  |  |  |  | 0 | 3 | -3 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
[NAME] |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name3 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name4 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name5 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name6 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name7 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name8 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name9 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name10 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name11 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name12 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name13 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name14 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
> 4 hours of work time = 1 hours removed
2-4 hours of work time = 0.5 hours removed
< 2 hours of work time = 0 hours removed