Spreadsheet: 116232d1311692938-macro-to-change-sheet-name-within-a-formula-time-cards-group_example
Sheet: 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
Name 1 |  |  |  |  | 0 | 3 | -3 |  |  |  |  | 0 | 5 | -5 |  |  |  |  | 0 | 7 | -7 |  |  |  |  | 0 | 1 | -1 |  |  |  |  | 0 | 2 | -2 |  |  | 0 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name 2 |  |  |  |  | 0 | 5 | -5 |  |  |  |  | 0 | 3 | -3 |  |  |  |  | 0 | 1 | -1 |  |  |  |  | 0 | 1 | -1 |  |  |  |  | 0 | 1 | -1 |  |  | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name 3 |  | 8 |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
Name 4 |  |  |  |  | 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
Name 5 |  |  |  |  | 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
Name 6 |  |  |  |  | 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
Name 7 |  |  |  |  | 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
Name 8 |  |  |  |  | 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
Name 9 |  |  |  |  | 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
Name 10 |  |  |  |  | 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
Name 11 |  |  |  |  | 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
Name 12 |  |  |  |  | 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
Name 13 |  |  |  |  | 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
Name 14 |  |  |  |  | 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
Name 15 |  |  |  |  | 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
Name 16 |  |  |  |  | 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 |  |  | 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