Calculator On and Off.xlsx

	A	B	C	D	F	H	I	J
1	Name	Days On	Days Off	Daily Hours	Sum (Weekly)	Over 7 Days	Over 5 Days	Over 3 Days
2	John Smith	5.00	3.00	8.50	37.19	5.31	7.44	12.40
3	Jane Smith	4.00	4.00	4.50	15.75	2.25	3.15	5.25
4	Jessica Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
5	Joseph Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
6	Jacob Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
7	Jack Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
8	James Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
9	Jennifer Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
10	Julia Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
11	Jake Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
12	Janice Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
13	Jericho Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
14	Jerry Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
15	Janet Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
16	Jason Smith	5.00	2.00	8.00	40.00	5.71	8.00	13.33
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100