ABCDEFGHIJKL
1
DAYSTARTENDSTARTENDTOTALHRSNOTES
2
3
2018-01-01MON8:00 AM9:00 AM01:001Day OffINSTRUCTIONS:

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-02TUE0
5
2018-01-03WED0
6
2018-01-04THU0Rehearsal
7
2018-01-05FRI0
8
2018-01-06SAT0Day Off
9
2018-01-07SUN0
10
1AVERAGE1
11
2018-01-01MON0Day OffINSTRUCTIONS:

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-02TUE8:00 AM12:00 PM1:00 PM5:00 PM08:008
13
2018-01-03WED9:00 AM12:00 PM1:00 PM5:00 PM07:007
14
2018-01-04THU9:00 AM5:00 PM7:00 PM9:00 PM10:0010Rehearsal
15
2018-01-05FRI9:00 AM1:00 PM2:00 PM6:00 PM08:008
16
2018-01-06SAT0Day Off
17
2018-01-07SUN7:00 AM12:00 PM4:00 PM7:00 PM08:008
18
41AVERAGE41
19
2018-01-08MON0
20
2018-01-09TUE0
21
2018-01-10WED0
22
2018-01-11THU0
23
2018-01-12FRI0
24
2018-01-13SAT0
25
2018-01-14SUN0
26
21AVERAGE0
27
2018-01-15MON0
28
2018-01-16TUE0
29
2018-01-17WED0
30
2018-01-18THU0
31
2018-01-19FRI0
32
2018-01-20SAT0
33
2018-01-21SUN0
34
14AVERAGE0
35
2018-01-22MON0
36
2018-01-23TUE0
37
2018-01-24WED0
38
2018-01-25THU0
39
2018-01-26FRI0
40
2018-01-27SAT0
41
2018-01-28SUN0
42
10AVERAGE0
43