Spreadsheet: 110110d1306880304-calculating-times-ranges-tiathlon4
Sheet: PivotTable

 | Wave | SAT1
 | Club | (All)
 | Total | (Multiple Items)
 |  | Data
 | RaceNr | Sum of Total2 | Sum of Total | Sum of SwimTot2 | Sum of SwimTot | Sum of [NAME] | Sum of BikeTot2 | Sum of RunTot | Sum of RunTot2
 | 232 | 00:39:04 | 3 | 00:07:21 | 3
 | 202 | 00:39:43 | 5 | 00:07:28 | 6 | 00:17:30 | 1 | 00:10:30 | 11
 | 233 | 00:38:49 | 2 | 00:07:29 | 7 | 00:17:35 | 2 | 00:09:39 | 2
 | 254 | 00:39:46 | 6 | 00:07:32 | 10 | 00:17:37 | 3 | 00:10:28 | 10
 | 236 | 00:39:36 | 4 | 00:07:31 | 9 | 00:17:38 | 4 | 00:10:16 | 8
 | 227 | 00:38:24 | 1 | 00:07:01 | 1 | 00:17:43 | 5 | 00:09:18 | 1
 | 241 | 00:40:50 | 12 | 00:07:55 | 22 | 00:17:43 | 5 | 00:10:42 | 15
 | 255 | 00:41:55 | 17 | 00:07:43 | 15 | 00:17:47 | 6 | 00:11:42 | 29
 | 271 | 00:40:11 | 7 | 00:07:53 | 20 | 00:17:51 | 7 | 00:10:09 | 4
 | 226 | 00:40:24 | 9 | 00:07:33 | 11 | 00:18:00 | 8 | 00:10:11 | 5
 | 275 | 00:40:33 | 11 | 00:07:38 | 14 | 00:18:05 | 9 | 00:10:15 | 7
 | 231 | 00:40:27 | 10 | 00:07:37 | 13 | 00:18:10 | 10 | 00:10:17 | 9
 | 235 | 00:40:12 | 8 | 00:07:31 | 9 | 00:18:11 | 11 | 00:10:12 | 6
 | 243 | 00:41:10 | 14 | 00:07:26 | 4 | 00:18:30 | 12 | 00:10:51 | 19
 | 229 | 00:40:51 | 13 | 00:07:14 | 2 | 00:18:32 | 13 | 00:11:06 | 23
 | 250 | 00:41:55 | 17 | 00:07:54 | 21 | 00:18:36 | 14 | 00:10:37 | 13
 | 223 | 00:41:44 | 16 | 00:07:34 | 12 | 00:18:55 | 15 | 00:10:47 | 16
 | 240 | 00:42:46 | 19 | 00:08:01 | 24 | 00:19:03 | 16 | 00:11:03 | 22
 | 260 | 00:41:41 | 15 | 00:07:26 | 4 | 00:19:09 | 17 | 00:10:38 | 14
 | 273 | 00:42:48 | 20 | 00:07:47 | 16 | 00:19:23 | 18 | 00:11:02 | 21
 | 209 | 00:44:16 | 25 | 00:09:13 | 31 | 00:19:26 | 19 | 00:10:55 | 20
 | 228 | 00:43:38 | 22 | 00:07:55 | 22 | 00:19:27 | 20 | 00:11:39 | 28
 | 239 | 00:44:12 | 24 | 00:07:27 | 5 | 00:19:34 | 21 | 00:12:12 | 36
 | 249 | 00:46:37 | 34 | 00:10:03 | 35 | 00:19:39 | 22 | 00:11:55 | 33
 | 210 | 00:44:26 | 26 | 00:07:49 | 17 | 00:19:57 | 23 | 00:11:54 | 32
 | 242 | 00:45:28 | 31 | 00:08:16 | 25 | 00:20:00 | 24 | 00:11:57 | 34
 | 215 | 00:42:49 | 21 | 00:07:51 | 18 | 00:20:06 | 25 | 00:10:35 | 12
 | 217 | 00:45:00 | 29 | 00:08:50 | 28 | 00:20:07 | 26 | 00:11:32 | 26
 | 211 | 00:42:34 | 18 | 00:07:30 | 8 | 00:20:08 | 27 | 00:10:30 | 11
 | 213 | 00:44:42 | 27 | 00:07:34 | 12 | 00:20:15 | 28 | 00:11:49 | 31
 | 206 | 00:43:49 | 23 | 00:07:54 | 21 | 00:20:20 | 29 | 00:10:48 | 17
 | 284 | 00:45:05 | 30 | 00:07:52 | 19 | 00:20:28 | 30 | 00:12:03 | 35
 | 237 | 00:44:52 | 28 | 00:07:57 | 23 | 00:20:38 | 31 | 00:11:06 | 23
 | 252 | 00:46:46 | 35 | 00:10:05 | 36 | 00:20:40 | 32 | 00:09:44 | 3
 | 272 | 00:46:51 | 36 | 00:08:57 | 29 | 00:20:58 | 33 | 00:11:39 | 28
 | 463 | 00:49:33 | 40 | 00:10:42 | 37 | 00:21:10 | 34 | 00:11:14 | 24
 | 464 | 00:47:34 | 37 | 00:09:52 | 34 | 00:21:17 | 35 | 00:10:50 | 18
 | 230 | 00:52:17 | 43 | 00:11:20 | 39 | 00:21:20 | 36 | 00:12:26 | 38
 | 203 | 00:45:30 | 32 | 00:07:32 | 10 | 00:21:22 | 37 | 00:11:38 | 27
 | 216 | 00:47:40 | 38 | 00:08:41 | 27 | 00:21:24 | 38 | 00:12:14 | 37
 | 208 | 00:46:23 | 33 | 00:07:57 | 23 | 00:21:37 | 39 | 00:11:27 | 25
 | 204 | 00:48:52 | 39 | 00:07:55 | 22 | 00:21:41 | 40 | 00:14:00 | 45
 | 221 | 00:50:13 | 41 | 00:08:31 | 26 | 00:22:19 | 41 | 00:13:05 | 41
 | 248 | 00:53:11 | 44 | 00:09:47 | 32 | 00:22:39 | 42 | 00:12:44 | 39
 | 251 | 00:56:05 | 47 | 00:10:58 | 38 | 00:23:14 | 43 | 00:13:43 | 42
 | 207 | 00:51:50 | 42 | 00:09:49 | 33 | 00:23:42 | 44 | 00:12:56 | 40
 | 259 | 00:59:55 | 48 | 00:11:25 | 40 | 00:24:22 | 45 | 00:15:33 | 46
 | 261 | 00:54:34 | 46 | 00:11:44 | 42 | 00:24:38 | 46 | 00:11:48 | 30
 | 205 | 00:53:41 | 45 | 00:08:58 | 30 | 00:24:59 | 47 | 00:13:52 | 44
 | 218 | 01:02:20 | 49 | 00:11:35 | 41 | 00:26:39 | 48 | 00:16:25 | 47
 | 222 | 01:16:07 | 51 | 00:16:10 | 44 | 00:30:23 | 49 | 00:18:58 | 48
 | 253 | 01:11:23 | 50 | 00:13:30 | 43 | 00:34:38 | 50 | 00:13:44 | 43
 | Grand Total | 1900-01-01 16:11:02 |  | 07:33:13 |  | 17:35:05 |  | 09:56:38