Spreadsheet: 145101d1331308073-time-clock-help-timediff
Sheet: Time Sheet

Week 2 (2/6 - 2/12) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 1
Employee | Actual Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  | Employee | Projected Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out |  |  |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
A |  | 07:07:00 | 15:01:00 | 11:58:00 | 16:15:00 | 07:14:00 | 15:45:00 | 07:17:00 | 15:09:00 | 07:08:00 | 14:55:00 | OFF | OFF | OFF | OFF |  | A |  | OFF | OFF | OFF | OFF | 07:00:00 | 15:00:00 | 07:00:00 | 16:00:00 | OFF | OFF | OFF | OFF | OFF | OFF
B |  | 15:32:00 | 20:03:00 | 15:20:00 | 19:22:00 | 15:38:00 | 19:16:00 | OFF | OFF | 15:48:00 | 19:06:00 | 06:35:00 | 12:54:00 | 06:43:00 | 12:18:00 |  | B |  | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | OFF | OFF | 07:00:00 | 12:00:00 | 07:00:00 | 12:00:00
C |  | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF |  | C |  | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 09:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | OFF | OFF | OFF | OFF
D |  | 07:04:00 | 08:24:00 | 07:05:00 | 15:39:00 | 07:07:00 | 13:04:00 | 07:09:00 | 09:49:00 | OFF | OFF | 07:11:00 | 12:54:00 | 07:24:00 | 12:18:00 |  | D |  | 07:00:00 | 12:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 12:00:00 | 07:00:00 | 11:00:00 | OFF | OFF
E |  | 09:18:00 | 14:22:00 | 12:38:00 | 20:15:00 | Called Out | Called Out | 12:02:00 | 08:15:00 | 07:58:00 | 15:17:00 | OFF | OFF | OFF | OFF |  | E |  | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | OFF | OFF | OFF | OFF
F |  | 14:01:00 | 20:11:00 | 08:06:00 | 14:17:00 | OFF | OFF | 09:00:00 | 14:04:00 | 12:22:00 | 19:57:00 | 09:03:00 | 17:07:00 | 08:59:00 | 14:23:00 |  | F |  | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | OFF | OFF | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 17:00:00 | 08:00:00 | 14:00:00
G |  | OFF | OFF | OFF | OFF | 08:05:00 | 20:48:00 | OFF | OFF | OFF | OFF | 18:16:00 | 19:35:00 | 12:45:00 | 19:19:00 |  | G |  | OFF | OFF | OFF | OFF | 10:00:00 | 19:00:00 | OFF | OFF | OFF | OFF | 17:00:00 | 19:00:00 | 12:00:00 | 20:00:00
H |  | 05:15:00 | 14:02:00 | 05:06:00 | 14:11:00 | 05:07:00 | 14:09:00 | 05:12:00 | 09:05:00 | 05:08:00 | 14:03:00 | 05:07:00 | 14:05:00 | OFF | OFF |  | H |  | 05:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | 05:00:00 | 09:00:00 | 05:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | OFF | OFF
I |  | 05:55:00 | 14:05:00 | 05:56:00 | 14:00:00 | 05:54:00 | 13:59:00 | 06:03:00 | 11:30:00 | 06:07:00 | 14:05:00 | OFF | OFF | 04:57:00 | 14:16:00 |  | I |  | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 11:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 05:00:00 | 14:00:00
J |  | OFF | OFF | OFF | OFF | 05:07:00 | 13:05:00 | 05:20:00 | 13:05:00 | 05:10:00 | 13:06:00 | 05:14:00 | 13:05:00 | 05:13:00 | 13:06:00 |  | J |  | OFF | OFF | OFF | OFF | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00
K |  | 05:32:00 | 13:37:00 | 05:29:00 | 13:54:00 | OFF | OFF | OFF | OFF | 05:30:00 | 13:49:00 | 05:45:00 | 13:16:00 | 05:42:00 | 13:24:00 |  | K |  | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00 | OFF | OFF | OFF | OFF | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00
L |  | 09:59:00 | 16:07:00 | 12:34:00 | 20:13:00 | 11:46:00 | 20:12:00 | 12:02:00 | 20:20:00 | 12:23:00 | 19:58:00 | 09:04:00 | 16:09:00 | OFF | OFF |  | L |  | 09:00:00 | 16:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 09:00:00 | 16:00:00 | OFF | OFF
M |  | Called Out | Called Out | 09:23:00 | 17:17:00 | 09:23:00 | 17:06:00 | 09:05:00 | 17:28:00 | OFF | OFF | OFF | OFF | 12:20:00 | 18:08:00 |  | M |  | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | OFF | OFF | OFF | OFF | 12:00:00 | 18:00:00
N |  | 10:44:00 | 17:59:00 | OFF | OFF | 10:09:00 | 17:06:00 | 10:00:00 | 17:46:00 | OFF | OFF | 10:13:00 | 17:28:00 | 10:01:00 | 18:08:00 |  | N |  | 10:00:00 | 18:00:00 | OFF | OFF | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | OFF | OFF | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00
O |  | 12:50:00 | 20:17:00 | 12:13:00 | 19:54:00 | OFF | OFF | OFF | OFF | 12:27:00 | 19:57:00 | 12:11:00 | 19:36:00 | 12:12:00 | 19:19:00 |  | O |  | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | OFF | OFF | OFF | OFF | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00
Week 1 (2/13 - 2/19) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 2
Employee | Actual Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  | Employee | Projected Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out |  |  |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  | OFF | OFF | OFF | OFF | 07:00:00 | 15:00:00 | 07:00:00 | 16:00:00 | OFF | OFF | OFF | OFF | OFF | OFF
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | 15:30:00 | 17:30:00 | OFF | OFF | 07:00:00 | 12:00:00 | 07:00:00 | 12:00:00
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C |  | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 09:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | OFF | OFF | OFF | OFF
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D |  | 07:00:00 | 12:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 15:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 12:00:00 | 07:00:00 | 11:00:00 | OFF | OFF
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | OFF | OFF | 08:00:00 | 14:00:00
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F |  | 12:00:00 | 20:00:00 | 08:00:00 | 14:00:00 | OFF | OFF | 08:00:00 | 14:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 17:00:00 | OFF | OFF
G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G |  | OFF | OFF | OFF | OFF | 10:00:00 | 19:00:00 | OFF | OFF | OFF | OFF | 17:00:00 | 19:00:00 | 12:00:00 | 20:00:00
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | 05:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | 05:00:00 | 09:00:00 | 05:00:00 | 14:00:00 | OFF | OFF | 05:00:00 | 14:00:00
I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I |  | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 11:00:00 | 06:00:00 | 14:00:00 | 05:00:00 | 14:00:00 | OFF | OFF
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J |  | OFF | OFF | OFF | OFF | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00 | 05:00:00 | 13:00:00
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K |  | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00 | OFF | OFF | OFF | OFF | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00 | 05:30:00 | 13:30:00
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L |  | 09:00:00 | 16:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 09:00:00 | 16:00:00 | OFF | OFF
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M |  | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | 09:00:00 | 17:00:00 | OFF | OFF | OFF | OFF | 12:00:00 | 18:00:00
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  | 10:00:00 | 18:00:00 | OFF | OFF | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00 | OFF | OFF | 10:00:00 | 18:00:00 | 10:00:00 | 18:00:00
O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | OFF | OFF | OFF | OFF | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00 | 12:00:00 | 20:00:00
Week 2 (2/20 - 2/26)
Employee | Actual Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
Week 1 (2/27 - 3/4)
Employee | Actual Weekly Hours | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 |  | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O