Excel Pivot table Time Values is not populating same as Source Sheet

[Krish9999]

Hello Excel Experts, I am not able to Populate Time Values from my source sheet. Even I need to Sum up Time values in Pivot Table to show grand total. can you please help me or guide me to achieve this. very thank you in Advance

Year

Month

Agent Name

Inbound Handled

Outbound Handled

Inbound AHT

Outbound AHT

Avg Hold Time

Unavailable Time

Login Time

ACW Time

Refused

Available Time

Hold Time

Consult Time

Inbound Conference Time

Inbound Active Talk Time

Inbound Hold Time

Outbound Handle Time

Active Talk Time

Handle Time

Working Time

Occupancy

Inbound Handle Time

Speed Of Answer

2023

November

A​

0

2

0:00:00

00:21:49

0:00:00

00:05:45

00:48:19

00:01:29

0

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

00:43:38

00:42:09

00:43:38

00:44:03

100.00%

0:00:00

0:00:00

2023

November

B​

260

40

00:15:26

00:05:28

0:00:00

43:21:00

169:26:47

18:27:16

5

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

10:30:34

03:38:40

41:26:25

70:31:18

144:33:03

48.86%

66:52:37

00:12:15

2023

November

B​

315

12

00:12:13

00:04:56

0:00:00

27:21:59

162:21:21

08:11:37

0

78:00:59

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

00:59:09

56:55:22

65:06:59

143:10:59

45.49%

64:07:49

00:08:42

2023

November

C​

170

4

00:14:47

00:05:03

00:01:47

30:35:36

154:20:02

03:55:19

0

85:24:02

00:14:13

0:00:00

0:00:00

37:51:49

00:14:13

00:20:11

38:05:00

42:14:32

127:39:44

33.09%

41:54:21

00:04:50

2023

November

C​

260

1

00:12:50

00:04:38

0:00:00

36:27:19

175:24:55

08:28:57

0

91:47:07

0:00:00

0:00:00

0:00:00

47:10:07

0:00:00

00:04:38

47:10:17

55:39:14

147:26:33

37.75%

55:34:36

00:07:28

2023

November

D​

16

1

00:10:11

00:03:06

00:02:43

137:49:26

141:14:23

01:08:39

0

01:47:22

00:10:52

0:00:00

0:00:00

01:24:13

00:10:52

00:03:06

01:26:37

02:46:08

04:33:36

60.74%

02:43:02

00:00:23

2023

November

D​

178

0

00:08:50

0:00:00

0:00:00

23:07:58

107:27:46

02:28:58

1

60:35:49

0:00:00

0:00:00

0:00:00

23:43:53

0:00:00

0:00:00

23:43:53

26:12:50

86:48:45

30.20%

26:12:50

00:06:13

2023

November

E​

297

1

00:11:25

00:02:34

00:02:36

35:16:49

173:58:53

13:04:48

2

95:10:54

01:57:16

0:00:00

0:00:00

41:32:35

01:57:16

00:02:34

41:33:38

56:35:42

151:46:52

37.29%

56:33:08

00:10:41

2023

November

E​

224

9

00:13:00

00:10:18

0:00:00

42:17:49

149:43:42

21:39:04

36

78:58:56

0:00:00

0:00:00

0:00:00

27:28:54

0:00:00

01:32:46

28:24:59

50:04:03

129:04:57

38.80%

48:31:17

00:36:37

2023

November

F​

201

1

00:12:10

00:18:16

0:00:00

53:17:49

143:44:53

14:21:18

0

63:44:11

0:00:00

0:00:00

0:00:00

26:28:06

0:00:00

00:18:16

26:42:40

41:03:58

104:48:22

39.18%

40:45:42

00:07:05

2023

November

F​

185

9

00:13:22

00:04:51

00:02:18

27:22:53

131:57:31

08:15:07

0

70:50:08

01:02:06

0:00:00

0:00:00

32:23:01

01:02:06

00:43:37

32:40:22

41:57:35

112:49:44

37.20%

41:13:57

00:05:42

2023

November

G​

290

4

00:12:18

00:05:11

00:02:58

28:21:44

173:08:04

08:46:09

0

93:45:24

02:52:32

0:00:00

0:00:00

47:53:55

02:52:32

00:20:44

48:07:41

59:46:23

153:32:29

38.93%

59:25:39

00:09:40

2023

November

G​

4

0

00:09:57

0:00:00

00:02:00

00:55:20

02:14:02

00:06:06

0

00:44:59

00:02:00

0:00:00

0:00:00

00:31:43

00:02:00

0:00:00

00:31:43

00:39:50

01:24:48

46.97%

00:39:50

00:00:08

2023

November

H​

286

11

00:12:06

00:05:31

00:03:40

24:38:23

167:58:02

07:54:20

0

92:28:12

02:48:23

0:00:00

0:00:00

47:16:25

02:45:50

01:00:40

47:57:54

58:40:36

151:13:59

38.82%

57:39:57

00:09:17

2023

November

H​

5

1

00:11:02

00:04:11

00:01:48

132:25:53

133:05:19

00:23:44

0

00:03:25

00:03:36

0:00:00

0:00:00

00:29:25

00:03:36

00:04:11

00:32:00

00:59:20

01:03:10

94.56%

00:55:09

00:00:08

2023

November

I​

300

21

00:11:09

00:03:38

00:02:21

34:17:14

173:40:02

06:18:08

1

88:24:22

00:07:02

00:11:13

0:00:00

49:50:19

00:07:02

01:16:19

50:34:59

57:00:09

145:40:56

39.20%

55:43:51

00:09:29

2023

November

I​

217

3

00:09:36

00:06:38

00:04:16

51:06:03

167:48:46

14:46:18

103

96:26:14

03:58:58

0:00:00

0:00:00

16:08:23

03:53:30

00:19:53

16:17:01

35:02:18

131:29:01

26.65%

34:42:25

01:25:31

2023

November

J​

2

0

00:13:58

0:00:00

0:00:00

156:23:14

157:04:51

00:12:53

9

00:25:26

0:00:00

00:01:08

0:00:00

00:15:02

0:00:00

0:00:00

00:15:02

00:27:55

00:54:30

52.32%

00:27:55

00:07:22

2023

November

J​

3

1

00:10:17

00:05:11

0:00:00

150:33:04

152:07:14

00:18:28

17

01:16:12

0:00:00

0:00:00

0:00:00

00:16:40

0:00:00

00:05:11

00:17:34

00:36:02

01:52:38

32.11%

00:30:51

00:18:06

2023

November

K​

345

26

00:08:13

00:02:29

00:01:07

26:30:03

160:54:14

03:23:51

0

89:20:57

00:20:02

0:00:00

0:00:00

43:52:58

00:20:02

01:04:44

44:37:52

48:21:45

137:48:02

35.12%

47:17:01

00:10:06

2023

November

K​

11

1

00:12:23

00:00:54

0:00:00

162:29:24

165:10:12

00:23:41

0

00:47:09

0:00:00

0:00:00

0:00:00

01:52:36

0:00:00

00:00:54

01:53:30

02:17:12

03:04:29

74.42%

02:16:18

00:00:17

2023

November

L​

254

16

00:14:01

00:07:32

00:00:22

27:59:05

149:28:56

07:31:23

0

67:35:45

00:01:06

0:00:00

0:00:00

52:27:33

00:01:06

02:00:30

53:48:51

61:21:20

129:01:14

47.58%

59:20:50

00:07:50

2023

November

L​

148

10

00:18:38

00:10:19

00:04:38

22:00:44

108:24:58

08:04:57

0

46:49:10

00:04:38

0:00:00

0:00:00

38:12:04

00:04:38

01:43:05

39:32:16

47:41:51

94:29:11

50.46%

45:58:46

00:04:27

2023

November

M​

294

6

00:09:37

00:04:10

00:04:51

50:14:00

99:25:36

17:34:37

173

19:12:01

05:53:55

0:00:00

0:00:00

23:56:46

05:53:55

00:25:02

24:03:25

47:31:57

66:46:13

71.23%

47:06:56

02:22:17

2023

November

M​

193

64

00:13:08

00:06:50

00:03:58

38:21:09

162:26:33

04:00:15

0

78:16:24

00:03:58

0:00:00

0:00:00

39:06:04

00:03:58

07:17:23

45:26:37

49:30:49

128:05:39

38.75%

42:13:26

00:05:57

2023

November

N​

11

5

00:12:49

00:01:34

00:03:01

110:46:34

112:44:47

00:45:20

0

00:13:01

00:06:03

0:00:00

0:00:00

01:32:07

00:06:03

00:07:49

01:37:23

02:28:46

02:43:33

91.95%

02:20:57

00:00:16

2023

November

N​

272

16

00:14:13

00:06:49

00:03:20

54:50:14

179:23:59

23:31:24

0

81:45:30

05:19:13

0:00:00

0:00:00

36:34:57

05:18:38

01:48:59

37:26:27

66:17:04

148:05:09

44.77%

64:28:05

00:07:34

2023

November

O​

359

13

00:09:18

00:03:41

00:01:32

36:48:21

174:43:28

11:45:51

1

93:09:46

00:06:07

0:00:00

0:00:00

44:18:38

00:06:07

00:47:53

44:34:11

56:26:09

149:40:58

37.72%

55:38:16

00:10:50

2023

November

O​

357

22

00:11:13

00:06:50

00:02:28

33:27:40

175:52:40

12:42:54

0

85:47:09

00:19:46

0:00:00

0:00:00

54:24:26

00:19:46

02:30:14

56:12:22

69:15:03

155:07:55

44.67%

66:44:48

00:09:16

2023

November

P​

174

3

00:11:57

00:11:53

00:03:04

38:13:41

120:57:28

11:42:54

32

59:12:24

00:09:12

0:00:00

0:00:00

22:51:36

00:09:12

00:35:38

23:21:45

35:13:51

94:26:41

37.31%

34:38:13

00:32:11

2023

November

P​

233

2

00:10:59

00:06:49

00:03:20

18:58:46

117:10:12

04:14:11

0

59:31:15

00:40:00

0:00:00

0:00:00

37:48:48

00:40:00

00:13:38

37:59:41

42:53:52

102:25:37

41.88%

42:40:14

00:06:20

2023

November

Q​

0

0

0:00:00

0:00:00

0:00:00

21:53:22

23:47:14

0:00:00

0

0:00:00

0:00:00

01:53:52

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

01:53:52

0.00%

0:00:00

0:00:00

2023

November

Q​

223

11

00:14:50

0:00:00

0:00:00

36:48:56

152:23:30

0:00:00

0

0:00:00

0:00:00

0:00:00

0:00:00

40:01:00

04:27:51

01:33:00

41:00:58

56:41:40

126:40:44

44.77%

55:08:40

00:07:20

2023

November

R​

60

0

00:16:24

0:00:00

0:00:00

08:07:17

38:27:37

03:57:38

2

17:53:35

0:00:00

0:00:00

0:00:00

12:26:43

0:00:00

0:00:00

12:26:43

16:24:20

34:17:58

47.83%

16:24:20

00:03:35

2023

November

R​

248

3

00:11:29

00:08:07

0:00:00

38:25:32

161:13:11

07:19:50

2

82:14:41

0:00:00

0:00:00

0:00:00

40:12:02

0:00:00

00:24:22

40:31:42

47:51:31

130:07:29

36.79%

47:27:09

00:09:34

2023

November

S​

256

41

00:14:53

00:07:10

00:05:16

44:53:11

173:47:26

17:44:11

5

78:57:02

01:50:27

00:10:52

0:00:00

46:05:51

01:50:27

04:53:42

48:47:47

68:22:26

146:38:27

46.41%

63:28:43

00:10:43

2023

November

S​

262

6

00:11:18

00:04:59

00:01:58

31:40:46

146:06:06

10:14:06

5

74:45:20

00:03:57

0:00:00

0:00:00

39:25:28

00:03:57

00:29:55

39:33:08

49:51:11

124:39:26

40.01%

49:21:16

00:11:30

2023

November

T​

241

9

00:09:35

00:02:08

0:00:00

33:28:16

148:33:11

07:35:03

0

83:48:48

0:00:00

0:00:00

0:00:00

31:12:15

0:00:00

00:19:10

31:13:49

38:48:52

122:39:58

31.65%

38:29:42

00:08:21

2023

November

T​

35

15

00:12:34

00:06:05

00:00:01

156:46:32

171:53:24

01:48:53

0

07:59:53

00:00:01

0:00:00

0:00:00

05:55:16

00:00:01

01:31:09

07:01:53

08:50:47

16:55:44

52.52%

07:19:38

00:00:58

2023

November

U​

244

0

00:06:50

0:00:00

00:01:37

19:27:27

105:58:30

05:39:15

1

64:21:33

00:06:26

0:00:00

0:00:00

22:02:55

00:06:26

0:00:00

22:02:55

27:48:36

92:10:17

30.17%

27:48:36

00:08:49

2023

November

U​

172

1

00:18:41

00:12:12

00:06:48

30:12:42

129:20:15

14:39:29

10

59:59:59

11:39:49

0:00:00

0:00:00

27:22:01

11:39:49

00:12:12

27:27:32

53:46:50

113:47:02

47.27%

53:34:38

00:12:38

2023

November

V​

230

22

00:12:03

00:08:24

00:02:29

35:31:17

119:35:59

18:22:34

8

53:05:42

02:23:49

0:00:00

0:00:00

27:32:35

02:23:49

03:04:37

28:31:00

49:17:23

102:27:16

48.14%

46:12:46

00:16:08

2023

November

V​

363

36

00:09:30

00:02:44

0:00:00

29:02:06

171:18:22

08:10:34

5

91:06:39

0:00:00

0:00:00

0:00:00

49:50:17

0:00:00

01:38:25

50:59:20

59:09:53

150:26:50

39.37%

57:31:28

00:14:18

2023

November

W​

24

4

00:09:24

00:15:54

00:03:35

119:19:02

127:29:17

02:00:41

1

05:20:11

00:35:51

0:00:00

0:00:00

01:50:43

00:35:51

01:03:37

02:12:46

04:49:18

10:10:56

47.47%

03:45:41

00:01:23

2023

November

W​

166

4

00:09:23

00:01:36

00:03:19

21:19:28

81:59:36

04:09:14

1

38:44:20

01:22:50

0:00:00

0:00:00

20:28:34

01:22:50

00:06:24

20:31:39

26:03:43

64:49:22

40.22%

25:57:18

00:06:11

2023

November

X​

276

15

00:11:20

00:02:56

00:01:24

36:00:42

170:40:05

10:19:29

0

92:03:51

01:07:16

0:00:00

0:00:00

41:10:49

01:07:16

00:44:00

41:23:05

52:49:49

144:58:51

36.46%

52:05:49

00:09:05

2023

November

X​

11

47

00:10:37

00:06:28

0:00:00

139:52:06

147:02:41

00:40:43

0

00:38:50

0:00:00

0:00:00

0:00:00

01:38:48

0:00:00

05:04:18

06:20:19

07:01:02

07:51:18

91.56%

01:56:44

00:00:16

2023

November

Y​

201

9

00:14:55

00:13:42

00:03:19

51:43:10

142:45:04

19:22:41

4

58:20:45

00:33:14

0:00:00

0:00:00

31:10:06

00:33:10

02:03:16

32:05:26

52:01:20

110:24:34

47.14%

49:58:04

00:09:47

2023

November

Y​

321

9

00:06:46

00:05:38

00:00:07

34:18:05

143:16:01

01:46:10

0

73:38:45

00:00:20

0:00:00

0:00:00

34:29:10

00:00:20

00:50:43

35:16:37

37:03:06

110:44:06

33.47%

36:12:23

00:11:08

2023

November

Z​

269

12

00:12:52

00:06:51

00:02:34

30:15:50

147:29:41

16:28:25

4

74:34:58

02:44:39

0:00:00

0:00:00

39:30:15

02:44:39

01:22:08

39:50:03

59:03:07

133:42:16

44.19%

57:41:00

00:11:21

2023

November

Z​

266

6

00:12:12

00:09:34

00:02:36

55:16:28

152:08:18

24:58:21

3

66:44:28

01:33:20

0:00:00

0:00:00

28:08:27

01:33:20

00:57:23

28:31:43

55:03:24

121:50:11

45.20%

54:06:01

00:11:28

2023

November

[​

226

1

00:10:02

00:13:29

00:05:03

27:56:28

150:45:36

07:19:32

18

92:06:26

00:40:27

0:00:00

0:00:00

29:48:48

00:40:27

00:13:29

30:02:00

38:01:58

130:08:39

29.22%

37:48:30

00:21:16

2023

November

[​

164

4

00:13:55

00:02:33

00:04:19

40:41:51

157:14:46

10:26:41

0

88:44:29

08:29:12

0:00:00

0:00:00

19:15:46

08:29:12

00:10:10

19:17:38

38:13:30

126:59:36

30.11%

38:03:20

00:04:27

2023

November

\​

0

0

0:00:00

0:00:00

0:00:00

00:05:11

00:05:11

0:00:00

0

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0:00:00

0.00%

0:00:00

0:00:00

2023

November

\​

196

7

00:13:03

0:00:00

0:00:00

35:04:31

160:03:01

0:00:00

0

0:00:00

01:31:22

0:00:00

0:00:00

32:39:31

01:31:22

00:51:30

33:13:05

43:29:07

133:43:10

32.53%

42:37:37

00:05:36

2023

November

]​

291

5

00:12:11

00:02:35

00:02:13

26:45:25

176:45:12

06:14:17

0

96:53:11

01:26:32

0:00:00

0:00:00

51:31:37

01:26:32

00:12:54

51:38:06

59:18:56

156:14:04

37.97%

59:06:02

00:07:30

2023

November

]​

315

9

00:12:52

00:06:53

00:05:59

59:03:10

155:45:42

23:41:44

0

51:47:44

01:05:50

0:00:00

0:00:00

43:36:04

01:05:50

01:02:01

43:46:38

68:34:12

120:24:16

56.97%

67:32:11

00:10:06

2023

November

^​

6

1

00:19:34

00:10:26

00:03:57

180:17:00

181:57:03

00:43:19

1

00:15:26

00:03:57

0:00:00

0:00:00

01:10:29

00:03:57

00:10:26

01:20:33

02:07:49

02:23:22

89.23%

01:57:22

00:00:53

2023

November

^​

254

0

00:07:57

0:00:00

00:01:50

50:45:34

177:15:10

13:03:26

0

105:52:39

03:57:24

0:00:00

0:00:00

16:39:24

03:57:24

0:00:00

16:39:24

33:40:13

139:33:02

24.13%

33:40:13

00:08:45

2023

November

_​

256

13

00:16:32

00:06:45

00:02:39

40:29:10

164:25:23

22:55:38

1

74:50:00

04:22:08

0:00:00

0:00:00

43:54:55

04:22:06

01:27:44

44:41:45

71:59:31

146:51:51

49.03%

70:31:47

00:09:06

2023

November

_​

215

10

00:16:57

00:07:06

00:04:46

43:16:12

154:38:15

15:48:39

2

65:13:10

04:17:37

0:00:00

0:00:00

41:15:19

04:17:37

01:11:01

41:48:23

61:54:38

127:10:42

48.70%

60:43:37

00:10:34

2023

November

`​

16

27

00:14:55

00:05:22

00:02:55

159:08:22

165:44:45

00:27:14

0

00:32:16

00:14:34

0:00:00

0:00:00

03:28:34

00:09:44

02:24:51

05:41:45

06:23:34

07:03:37

92.24%

03:58:43

00:00:26

2023

November

`​

3

0

00:13:25

0:00:00

0:00:00

05:46:43

06:20:42

00:16:07

0

00:09:50

0:00:00

0:00:00

0:00:00

00:24:09

0:00:00

0:00:00

00:24:09

00:40:16

00:50:06

80.37%

00:40:16

00:00:06

2023

November

a​

286

5

00:12:16

00:06:02

00:04:02

37:50:26

169:00:56

10:43:58

4

82:55:33

04:50:45

0:00:00

0:00:00

43:06:13

04:50:45

00:30:08

43:23:23

58:58:06

141:54:28

41.56%

58:27:58

00:11:07

2023

November

a​

243

2

00:10:17

00:09:14

00:04:17

31:14:13

148:51:57

15:48:44

36

91:29:48

02:04:18

0:00:00

0:00:00

23:58:04

02:04:18

00:18:27

24:02:45

41:55:47

133:26:27

31.43%

41:37:20

00:36:39

2023

November

b​

305

13

00:12:44

00:10:30

00:00:02

47:55:37

174:56:08

21:05:12

0

81:00:39

00:00:02

0:00:00

0:00:00

44:52:44

00:00:02

02:16:26

45:55:51

67:01:05

148:05:44

45.27%

64:44:39

00:08:55

2023

November

b​

306

10

00:11:16

00:05:52

0:00:00

32:15:12

179:12:25

08:39:12

1

97:05:11

0:00:00

0:00:00

0:00:00

48:52:35

0:00:00

00:58:40

49:49:31

58:28:43

155:36:26

37.59%

57:30:03

00:10:02

2023

November

c​

377

5

00:09:15

00:01:57

00:01:23

45:14:06

172:46:47

10:12:47

1

79:29:11

00:04:08

0:00:00

0:00:00

47:54:35

00:04:08

00:09:45

47:58:01

58:14:55

137:45:28

42.29%

58:05:11

00:14:47

 

[awoohaw]

I can't see how youre displaying the format for the SUM of time.
But, the SUM seems to work for me:

Book2
	A	B	C	D	E	F	G	H
1	Year	Month	Agent Name	Speed Of Answer
2	2023.00	November	A	00:00:00
3	2023.00	November	B	00:12:15
4	2023.00	November	B	00:08:42
5	2023.00	November	C	00:04:50
6	2023.00	November	C	00:07:28
7	2023.00	November	D	00:00:23
8	2023.00	November	D	00:06:13
9	2023.00	November	E	00:10:41
10	2023.00	November	E	00:36:37
11	2023.00	November	F	00:07:05
12	2023.00	November	F	00:05:42
13	2023.00	November	G	00:09:40
14	2023.00	November	G	00:00:08
15	2023.00	November	H	00:09:17
16	2023.00	November	H	00:00:08
17	2023.00	November	I	00:09:29
18	2023.00	November	I	01:25:31
19	2023.00	November	J	00:07:22
20	2023.00	November	J	00:18:06
21	2023.00	November	K	00:10:06
22	2023.00	November	K	00:00:17
23	2023.00	November	L	00:07:50
24	2023.00	November	L	00:04:27
25	2023.00	November	M	02:22:17
26	2023.00	November	M	00:05:57
27	2023.00	November	N	00:00:16
28	2023.00	November	N	00:07:34
29	2023.00	November	O	00:10:50
30	2023.00	November	O	00:09:16
31	2023.00	November	P	00:32:11
32	2023.00	November	P	00:06:20
33	2023.00	November	Q	00:00:00
34	2023.00	November	Q	00:07:20
35	2023.00	November	R	00:03:35
36	2023.00	November	R	00:09:34
37	2023.00	November	S	00:10:43
38	2023.00	November	S	00:11:30
39	2023.00	November	T	00:08:21
40	2023.00	November	T	00:00:58
41	2023.00	November	U	00:08:49
42	2023.00	November	U	00:12:38
43	2023.00	November	V	00:16:08
44	2023.00	November	V	00:14:18
45	2023.00	November	W	00:01:23
46	2023.00	November	W	00:06:11
47	2023.00	November	X	00:09:05
48	2023.00	November	X	00:00:16
49	2023.00	November	Y	00:09:47
50	2023.00	November	Y	00:11:08
51	2023.00	November	Z	00:11:21
52	2023.00	November	Z	00:11:28
53	2023.00	November	[	00:21:16
54	2023.00	November	[	00:04:27
55	2023.00	November	\	00:00:00
56	2023.00	November	\	00:05:36
57	2023.00	November	]	00:07:30
58	2023.00	November	]	00:10:06
59	2023.00	November	^	00:00:53
60	2023.00	November	^	00:08:45
61	2023.00	November	_	00:09:06
62	2023.00	November	_	00:10:34
63	2023.00	November	`	00:00:26
64	2023.00	November	`	00:00:06
65	2023.00	November	Aa	00:11:07
66	2023.00	November	Aa	00:36:39
67	2023.00	November	Bb	00:08:55
68	2023.00	November	Bb	00:10:02
69	2023.00	November	Cc	00:14:47
70
71
72
73	Agent Name			Row Labels	Sum of Speed Of Answer		Check
74	A	00:00:00		[	00:25:43		TRUE
75	Aa	00:47:46		\	00:05:36		TRUE
76	B	00:20:57		]	00:17:36		TRUE
77	Bb	00:18:57		^	00:09:38		TRUE
78	C	00:12:18		_	00:19:40		TRUE
79	Cc	00:14:47		`	00:00:32		TRUE
80	D	00:06:36		A	00:00:00		TRUE
81	E	00:47:18		Aa	00:47:46		TRUE
82	F	00:12:47		B	00:20:57		TRUE
83	G	00:09:48		Bb	00:18:57		TRUE
84	H	00:09:25		C	00:12:18		TRUE
85	I	01:35:00		Cc	00:14:47		TRUE
86	J	00:25:28		D	00:06:36		TRUE
87	K	00:10:23		E	00:47:18		TRUE
88	L	00:12:17		F	00:12:47		TRUE
89	M	02:28:14		G	00:09:48		TRUE
90	N	00:07:50		H	00:09:25		TRUE
91	O	00:20:06		I	01:35:00		TRUE
92	P	00:38:31		J	00:25:28		TRUE
93	Q	00:07:20		K	00:10:23		TRUE
94	R	00:13:09		L	00:12:17		TRUE
95	S	00:22:13		M	02:28:14		TRUE
96	T	00:09:19		N	00:07:50		TRUE
97	U	00:21:27		O	00:20:06		TRUE
98	V	00:30:26		P	00:38:31		TRUE
99	W	00:07:34		Q	00:07:20		TRUE
100	X	00:09:21		R	00:13:09		TRUE
101	Y	00:20:55		S	00:22:13		TRUE
102	Z	00:22:49		T	00:09:19		TRUE
103	[	00:25:43		U	00:21:27		TRUE
104	\	00:05:36		V	00:30:26		TRUE
105	]	00:17:36		W	00:07:34		TRUE
106	^	00:09:38		X	00:09:21		TRUE
107	_	00:19:40		Y	00:20:55		TRUE
108	`	00:00:32		Z	00:22:49		TRUE
109				Grand Total	13:21:46
110
Sheet1

Cell Formulas
Range	Formula
B74:B108	B74	=SUMIF($C$2:$C$69,A74,$D$2:$D$69)
G74:G108	G74	=ROUND(INDEX($B$74:$B$108,MATCH(D74,$A$74:$A$108,0)),6)=ROUND(E74,6)