Spreadsheet: 109005d1305912346-if-statement-if-true-make-cell-standout-time-sheet
Sheet: Sheet1

 |  |  |  |  | Time Sheet/Schedule
WEEK | # | SUN |  |  | MON |  |  | TUE |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT |  |  | HRS | PAY AVG | BIWKLY | GRSSPAY |  |  | Pay Rate
WEEK | 1 |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS | W/S |  | HRS |  |  |  |  |  |  | 1
2011-12-24 00:00:00 | 2011-04-30 00:00:00 |  |  |  | 17:00:00 | 21:30:00 |  | 16:15:00 | 21:30:00 |  | 17:15:00 | 21:30:00 |  | 17:00:00 | 21:30:00 |  |  |  |  | 08:30:00 | 17:00:00 |  |  |  |  |  |  |  | 1
 | ENTER ACTUAL TIME>> |  |  |  | 17:15:00 | 21:30:00 |  | 16:15:00 | 21:30:00 |  |  |  |  | 17:30:00 | 21:30:00 |  |  |  |  | 08:30:00 | 17:00:00
WEEK |  |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS | W/S |  | HRS
2011-05-01 00:00:00 | 2011-05-07 00:00:00 |  |  |  | 17:00:00 | 21:30:00 |  | 16:15:00 | 21:30:00 |  | 17:00:00 | 21:30:00 |  | 17:00:00 | 21:30:00 |  |  |  |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>> |  |  |  | 17:00:00 | 21:30:00 |  | 16:15:00 | 21:30:00 |  | 17:00:00 | 21:30:00 |  | 16:30:00 | 21:30:00 |  |  |  |  | 08:30:00 | 17:00:00
WEEK |  |  |  |  | P/F |  | HRS | P/F |  | HRS | P/F |  | HRS | P/F |  | HRS |  |  | HRS | P/F |  | HRS
2011-05-08 00:00:00 | 2011-05-14 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  |  |  |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>> |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  |  |  |  | 08:30:00 | 17:00:00
WEEK |  |  |  |  | P/F |  | HRS | P/F |  | HRS | P/F |  | HRS | P/F |  | HRS |  |  | HRS | P/F |  | HRS
2011-05-15 00:00:00 | 2011-05-21 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  |  |  |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>> |  |  |  | 08:30:00 | 17:00:00 |  | 11:00:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 10:00:00 | 17:00:00 |  | 08:30:00 | 17:00:00
WEEK |  |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS
2011-05-22 00:00:00 | 2011-05-28 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>>
WEEK |  |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS
2011-05-29 00:00:00 | 2011-06-04 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>>
WEEK |  |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS
2011-06-05 00:00:00 | 2011-06-11 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>>
WEEK |  |  |  |  | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS | W/S |  | HRS |  |  | HRS
2011-06-12 00:00:00 | 2011-06-18 00:00:00 |  |  |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00 |  | 08:30:00 | 17:00:00
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>
WEEK
 | ENTER ACTUAL TIME>>