A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DAY | START | END | START | END | TOTAL | HRS | NOTES | ||||
2 | ||||||||||||
3 | 2018-01-01 | MON | 8:00 AM | 9:00 AM | 01:00 | 1 | Day Off | INSTRUCTIONS: 1. Select the last week (example, rows 21 through 28) 2. Copy 3. Insert 8 rows below 4. Paste 5. Update the dates 6. update the Average formula by double clicking the bottom "0" in column D and adding "i12" to the beginning of the formula | ||||
4 | 2018-01-02 | TUE | 0 | |||||||||
5 | 2018-01-03 | WED | 0 | |||||||||
6 | 2018-01-04 | THU | 0 | Rehearsal | ||||||||
7 | 2018-01-05 | FRI | 0 | |||||||||
8 | 2018-01-06 | SAT | 0 | Day Off | ||||||||
9 | 2018-01-07 | SUN | 0 | |||||||||
10 | 1 | AVERAGE | 1 | |||||||||
11 | 2018-01-01 | MON | 0 | Day Off | INSTRUCTIONS: 1. Select the last week (example, rows 21 through 28) 2. Copy 3. Insert 8 rows below 4. Paste 5. Update the dates 6. update the Average formula by double clicking the bottom "0" in column D and adding "i12" to the beginning of the formula | |||||||
12 | 2018-01-02 | TUE | 8:00 AM | 12:00 PM | 1:00 PM | 5:00 PM | 08:00 | 8 | ||||
13 | 2018-01-03 | WED | 9:00 AM | 12:00 PM | 1:00 PM | 5:00 PM | 07:00 | 7 | ||||
14 | 2018-01-04 | THU | 9:00 AM | 5:00 PM | 7:00 PM | 9:00 PM | 10:00 | 10 | Rehearsal | |||
15 | 2018-01-05 | FRI | 9:00 AM | 1:00 PM | 2:00 PM | 6:00 PM | 08:00 | 8 | ||||
16 | 2018-01-06 | SAT | 0 | Day Off | ||||||||
17 | 2018-01-07 | SUN | 7:00 AM | 12:00 PM | 4:00 PM | 7:00 PM | 08:00 | 8 | ||||
18 | 41 | AVERAGE | 41 | |||||||||
19 | 2018-01-08 | MON | 0 | |||||||||
20 | 2018-01-09 | TUE | 0 | |||||||||
21 | 2018-01-10 | WED | 0 | |||||||||
22 | 2018-01-11 | THU | 0 | |||||||||
23 | 2018-01-12 | FRI | 0 | |||||||||
24 | 2018-01-13 | SAT | 0 | |||||||||
25 | 2018-01-14 | SUN | 0 | |||||||||
26 | 21 | AVERAGE | 0 | |||||||||
27 | 2018-01-15 | MON | 0 | |||||||||
28 | 2018-01-16 | TUE | 0 | |||||||||
29 | 2018-01-17 | WED | 0 | |||||||||
30 | 2018-01-18 | THU | 0 | |||||||||
31 | 2018-01-19 | FRI | 0 | |||||||||
32 | 2018-01-20 | SAT | 0 | |||||||||
33 | 2018-01-21 | SUN | 0 | |||||||||
34 | 14 | AVERAGE | 0 | |||||||||
35 | 2018-01-22 | MON | 0 | |||||||||
36 | 2018-01-23 | TUE | 0 | |||||||||
37 | 2018-01-24 | WED | 0 | |||||||||
38 | 2018-01-25 | THU | 0 | |||||||||
39 | 2018-01-26 | FRI | 0 | |||||||||
40 | 2018-01-27 | SAT | 0 | |||||||||
41 | 2018-01-28 | SUN | 0 | |||||||||
42 | 10 | AVERAGE | 0 | |||||||||
43 |