ABCDEFGH
1
2
DateHours workedGoogle Finance $ to R$ conversionGoogle Finance $ to R$ conversion with ArrayFormulaTotal
3
10-May-20128R$1.95$1.95R$15.63Hi Leniel:
4
17-Oct-20127R$2.03$2.03R$14.21Is dragging down the formula in cell E3 all the way down to E31 not acceptable?
5
28-May-20136R$2.07$2.07R$12.44
6
29-May-20135R$2.11$2.11R$10.54Yogi
7
31-May-20134R$2.14$2.14R$8.55
8
3-Jun-20139.5R$2.12$2.12R$20.15Hi Yogi... that's the problem... I'd like to get it automatically when adding a new row to the sheet.
9
4-Jun-201312R$2.12$2.12R$25.49
10
5-Jun-201310R$2.13$2.13R$21.27Got It ... I will work out a solution for you!
11
13-Aug-20135R$2.31$2.31R$11.55Yogi
12
15-Aug-20134R$2.34$2.34R$9.35
13
16-Aug-20137R$2.39$2.39R$16.73
14
17-Aug-20148.5R$2.26$2.26R$19.18
15
18-Aug-20149.5R$2.25$2.25R$21.40
16
19-Aug-201410R$2.24$2.24R$22.44
17
20-Aug-20146R$2.26$2.26R$13.56
18
21-Aug-20147R$2.27$2.27R$15.87
19
22-Aug-20147R$2.27$2.27R$15.91
20
23-Aug-20148R$2.27$2.27R$18.18
21
24-Aug-201510R$3.55$3.55R$35.48
22
25-Aug-201512R$3.61$3.61R$43.34
23
26-Aug-201515R$3.59$3.59R$53.91
24
27-Aug-201516R$3.55$3.55R$56.80
25
28-Aug-20156R$3.58$3.58R$21.47
26
29-Aug-20157#N/A#N/A
27
1-Sep-20168R$3.25$3.25R$26.03
28
2-Sep-20169R$3.25$3.25R$29.28
29
3-Sep-201610R$3.26$3.26R$32.56
30
4-Sep-20179R$3.14$3.14R$28.25
31
5-Sep-20178R$3.12$3.12R$24.93
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