A
B
C
D
E
1
Time
Rate
Pay
2
2:15
$ 54.00
$ 121.50
D2: =B2*C2*24
3
3:45
$ 72.00
$ 270.00
4
2:09
$ 54.00
$ 116.10
5
Total
8:09
$ 507.60
B5: =SUM(B1:B4)
6
Avg Rate
$ 62.28
C6: =D5/B5/24