Spreadsheet: 63056d1264016223-repeat-and-automatically-add-existing-formula-in-new-page-or-row-timelogexample
Sheet: Weekly Time Log

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEKLY TIME LOG
 | WE DATE: | 2010-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | JUWI  CONSTRUCTION SITE SAFETY LOG SHEET
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEWKIRK CONSTRUCTION LOCATION: Greensboro, NC
 |  |  | Monday | 2010-01-11 00:00:00 |  |  |  |  | Tuesday | 2010-01-12 00:00:00 |  |  |  |  | Wednesday | 2010-01-13 00:00:00 |  |  |  |  |  |  | Thursday | 2010-01-14 00:00:00 |  |  |  |  | Friday | 2010-01-15 00:00:00 |  |  |  |  | Saturday | 2010-01-16 00:00:00 |  |  |  |  |  | Not Calculated Automatically
Count | PRINT NAME | CLASS | NOTE | IN | LUNCH OUT | LUNCH IN | OUT | TOTAL HOURS | NOTE | IN | LUNCH OUT | LUNCH IN | OUT | HOURS | NOTE | IN | LUNCH OUT | LUNCH IN | OUT | HOURS | # | PRINT NAME | NOTE | IN | LUNCH OUT | LUNCH IN | OUT | HOURS | NOTE | IN | LUNCH OUT | LUNCH IN | END | HOURS | NOTE | IN | LUNCH OUT | LUNCH IN | END | HOURS | Total Hours | Regular Hours | OT Hours
1 | BRIGHT, [NAME] | OFFICE |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:30:00 | 8.999999999999998 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 14:30:00 | 16:30:00 | 6.000000000000002 | 1 | BRIGHT, [NAME] |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 31
2 | NASH, WILLIAM | SUP |  | 07:00:00 | 12:00:00 | 12:30:00 | 18:00:00 | 10.5 |  | 07:00:00 | 12:00:00 | 12:30:00 | 18:15:00 | 10.75 |  | 07:15:00 | 12:00:00 | 12:30:00 | 18:30:00 | 10.75 | 2 | NASH, WILLIAM |  | 07:00:00 | 12:00:00 | 12:30:00 | 19:30:00 | 12 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 43.99999999999999
3 | PHENICIE, NATE | IJW |  | 07:30:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8.5 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:15:00 | 8.75 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00 | 8.5 | 3 | PHENICIE, NATE |  | 07:00:00 | 12:00:00 | 12:30:00 | 17:00:00 | 9.5 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 35.25
4 | PIERSON, BOB | F |  | 07:30:00 | 12:00:00 | 12:30:00 | 17:30:00 | 9.499999999999998 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:15:00 | 8.75 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00 | 8.5 | 4 | PIERSON, BOB |  | 07:00:00 | 12:00:00 | 12:30:00 | 17:00:00 | 9.5 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 36.25
5 | CUSACK, THOMAS | OP |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 5 | CUSACK, THOMAS |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
6 | WHITAKER, [NAME] | F |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:30:00 | 8.999999999999998 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:15:00 | 8.75 |  | 08:00:00 | 12:00:00 | 12:30:00 | 17:00:00 | 8.5 | 6 | WHITAKER, [NAME] |  | 07:00:00 | 12:00:00 | 12:30:00 | 17:15:00 | 9.749999999999998 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 36
7 | SEXTON, STEVE | IJW |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | dr appt. | 09:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 6.999999999999999 | 7 | SEXTON, STEVE |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 31
8 | BEVERLY, DANIEL | CW1a | [NAME] appt | 08:00:00 |  |  | 10:30:00 | 2.5 | dr. note |  |  |  |  | 0 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 8 | BEVERLY, DANIEL |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 18.5
9 | BOWLES, DANIEL | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | call in sick |  |  |  |  | 0 | 9 | BOWLES, DANIEL |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 24
10 | CARTER, REGINALD | CE-2 |  |  |  |  |  | 0 | new hire | 09:30:00 | 12:00:00 | 12:30:00 | 16:30:00 | 6.5 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 10 | CARTER, REGINALD |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 22.5
11 | COLEMAN, JOSH | CW1a | new hire | 09:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 6.999999999999999 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 11 | COLEMAN, JOSH |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 31
12 | CONRAD, ZAC | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 12 | CONRAD, ZAC |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
13 | DEGRUY, [NAME] | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 13 | DEGRUY, [NAME] |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
14 | DILLARD, BRENT | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 14 | DILLARD, BRENT |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
15 | [NAME], ALDEAN | CW1a | new hire | 10:15:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5.75 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 15 | [NAME], ALDEAN |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 29.75
16 | [NAME], BRANDON | CW1a | new hire | 10:15:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5.75 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 16 | [NAME], BRANDON |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 29.75
17 | ELLEN, WILL | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 17 | ELLEN, WILL |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
18 | KIRKLAND, GERAD | CW1a | no show |  |  |  |  | 0 | no show |  |  |  |  | 0 | no show |  |  |  |  | 0 | 18 | KIRKLAND, GERAD | no show |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 0
19 | LOCKHART, ROGER | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | late | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 19 | LOCKHART, ROGER |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
20 | [NAME], DANIEL | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 20 | [NAME], DANIEL |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
21 | MELO, JAIME | CW1a | new hire | 11:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 21 | MELO, JAIME |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 29
22 | MURPHY, [NAME] | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | [NAME] appt. | 10:40:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5.333333333333333 | 22 | MURPHY, [NAME] |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 29.33333333333333
23 | OAKLEY, SUSAN | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | call in (late) | 10:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5.999999999999998 | 23 | OAKLEY, SUSAN | late | 10:15:00 | 12:00:00 | 12:30:00 | 16:30:00 | 5.75 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 29.33333333333333
24 | OWENS, DAMION | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | late | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 24 | OWENS, DAMION |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
25 | PATRICK, [NAME] | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | late | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 25 | PATRICK, [NAME] |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
26 | PECHE, CHRISTOPHER | CW1a | call in |  |  |  |  | 0 | call in |  |  |  |  | 0 | late | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 26 | PECHE, CHRISTOPHER |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 16
27 | VARNER, DARREN | CW1a |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 27 | VARNER, DARREN |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 32
 |  |  |  |  |  |  |  | Daily Total |  |  |  |  |  | Daily Total |  |  |  |  |  | Daily Total |  |  |  |  |  |  |  | Daily Total |  |  |  |  |  | Daily Total |  |  |  |  |  | Daily Total | Weekly Total
 |  |  |  |  |  |  |  | 184.5 |  |  |  |  |  | 195.5 |  |  |  |  |  | 196.5833333333333 |  |  |  |  |  |  |  | 214.5 |  |  |  |  |  | 0 |  |  |  |  |  | 0 | 791.0833333333334
 |  | [NAME]: Do not delete
 |  | Start | Lunch Out | Lunch In | End | Worked Hrs
 |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8
 |  | Employee Hours |  |  |  |  | 8 |  | Overtime Rate:
 |  | Name | Start | Lunch Out | Lunch In | End | Worked Hrs | [NAME] | [NAME]
 |  |  | 08:00:00 | 12:00:00 | 12:30:00 | 16:30:00 | 8 | 8 | #N/A
 |  |  | 08:30:00 | 11:30:00 | 12:30:00 | 18:30:00 | 9 | 9 | #N/A
 |  |  | 08:45:00 | 12:30:00 | 13:15:00 | 16:30:00 | 7 | 7 | #N/A
 |  |  | 09:15:00 | 13:00:00 | 14:15:00 | 20:15:00 | 9.749999999999998 | 9.749999999999998 | #N/A
 |  |  | 22:00:00 | 23:00:00 | 00:30:00 | 07:00:00 | 7.5 | 7.5 | #N/A
 |  | Employee Hours |  |  |  |  | Regular Hours: | 8 |  | Overtime Rate: | 1.5
 |  | Name | Start | Lunch Out | Lunch In | End | Total Hrs | Worked Hrs | [NAME] | [NAME] | $/Hr | Reg $ | OT $ | TOTAL
 |  |  | 09:00:00 | 12:00:00 | 13:00:00 | 18:00:00 | 9 | 8 | 8 | 8 | 10 | 80 | 0 | 80
 |  |  | 08:30:00 | 11:30:00 | 12:30:00 | 18:30:00 | 10 | 9 | 9 | 9 | 10 | 90 | 0 | 90
 |  |  | 08:45:00 | 12:30:00 | 13:15:00 | 16:30:00 | 7.75 | 7 | 7 | 7 | 10 | 70 | 0 | 70
 |  |  | 09:15:00 | 13:00:00 | 14:15:00 | 20:15:00 | 11 | 9.749999999999998 | 9.749999999999998 | 9.749999999999998 | 10 | 97.49999999999999 | 0 | 97.49999999999999
 |  |  | 22:00:00 | 23:00:00 | 00:30:00 | 07:00:00 | 9 | 7.5 | 7.5 | 7.5 | 10 | 75 | 0 | 75
 |  | Start | Lunch Out | Lunch In | End | Total Hrs | Worked Hrs | [NAME]
 |  | 09:00:00 | 12:00:00 | 13:00:00 | 16:30:00 | 7.5 | 6.500000000000001 | 6.500000000000001