ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
March
2
2017
3
$20.00/hr
4
NameDateStartFinishTotal TimeCouponChargeAdjusted Price
5
Smith3/1/20178:00:00 AM5:00:00 PM9:00:00$180.00ANDORLOOKUP
6
Jones3/1/20179:00:00 AM12:00:00 PM3:00:00$60.00
7
Garcia3/1/20177:00:00 AM11:00:00 PM16:00:00$320.00
8
Wang3/2/20178:00:00 AM11:00:00 PM15:00:00$300.00
9
Mackey3/2/20175:00:00 PM2:00:00 AM-15:00:00-$300.00
10
Twain3/5/20174:00:00 AM12:00:00 PM8:00:00$160.00
11
Patterson
3/6/20174:00:00 PM9:00:00 PM5:00:00$100.00
12
Cashore3/8/20175:00:00 AM2:00:00 PM9:00:00$180.00
13
Lu3/12/20173:00:00 AM1:00:00 PM10:00:00$200.00
14
Reichs3/15/20173:00:00 PM8:00:00 PM5:00:00$100.00
15
Martini3/18/20176:00:00 AM2:00:00 PM8:00:00$160.00
16
Matrinez3/25/20176:00:00 PM11:30:00 PM5:30:00$110.00
17
Austen3/25/20175:00:00 AM10:00:00 AM5:00:00$100.00VLOOKUP
18
minsummax
19
average
20
21
22
23
24
25
26
27
28
29
30
$20.00/hrNAME
31
NameDateStartFinishTotal TimeCouponChargeAdjusted PriceLOOKUP
32
Mackey3/2/20175:00:00 PM2:00:00 AM-15:00:00-$300.00
33
Jones3/1/20179:00:00 AM12:00:00 PM3:00:00$60.00
34
Austen3/25/20175:00:00 AM10:00:00 AM5:00:00$100.00
35
Patterson
3/6/20174:00:00 PM9:00:00 PM5:00:00$100.00
36
Reichs3/15/20173:00:00 PM8:00:00 PM5:00:00$100.00
37
Matrinez3/25/20176:00:00 PM11:30:00 PM5:30:00$110.00
38
Martini3/18/20176:00:00 AM2:00:00 PM8:00:00$160.00
39
Twain3/5/20174:00:00 AM12:00:00 PM8:00:00$160.00
40
Cashore3/8/20175:00:00 AM2:00:00 PM9:00:00$180.00
41
Smith3/1/20178:00:00 AM5:00:00 PM9:00:00$180.00
42
Lu3/12/20173:00:00 AM1:00:00 PM10:00:00$200.00
43
Wang3/2/20178:00:00 AM11:00:00 PM15:00:00$300.00
44
Garcia3/1/20177:00:00 AM11:00:00 PM16:00:00$320.00
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