Spreadsheet: 109988d1306793136-calculating-times-ranges-triathaloncf
Sheet: Sheet1

Wave | RaceNr | Start | SwimFin | BikeStart | BikeFin | RunStart | RunTurn1 | RunFin | Total | SwimTot | [NAME] | RunTot | SwinRank | BikeRank | RunRank
SAT1 | 201 | 10:59:36
SAT1 | 214 | 10:59:36
SAT1 | 224 | 10:59:36
SAT1 | 234 | 10:59:36
SAT1 | 238 | 10:59:36
SAT1 | 245 | 10:59:36
SAT1 | 246 | 10:59:36
SAT1 | 247 | 10:59:36
SAT1 | 257 | 10:59:36 |  |  |  |  |  |  |  |  | I used Conditional Formatting on
SAT1 | 258 | 10:59:36 |  |  |  |  |  |  |  |  | These three columns
SAT1 | 262 | 10:59:36 |  |  |  |  |  |  |  |  | Highlight the whole column and [NAME] and Top
SAT1 | 263 | 10:59:36
SAT1 | 264 | 10:59:36
SAT1 | 265 | 10:59:36
SAT1 | 266 | 10:59:36
SAT1 | 267 | 10:59:36
SAT1 | 274 | 10:59:36
SAT1 | 227 | 10:59:36 | 11:06:37 | 11:09:07 | 11:26:50 | 11:28:42 | 11:33:13 | [NAME]
SAT1 | 229 | 10:59:36 | 11:06:50 | 11:09:13 | 11:27:45 | 11:29:21 | 11:34:22 | 11:40:27
SAT1 | 232 | 10:59:36 | 11:06:57 |  |  |  |  | 11:38:40 |  |  | 10 days, 0:00:00 | 10 days, 0:00:00
SAT1 | 243 | 10:59:36 | 11:07:02 | 11:09:32 | 11:28:02 | 11:29:55 | 11:35:09 | 11:40:46
SAT1 | 260 | 10:59:36 | 11:07:02 | 11:09:33 | 11:28:42 | 11:30:39 | 11:35:58 | 11:41:17
SAT1 | 239 | 10:59:36 | 11:07:03 | 11:10:00 | 11:29:34 | 11:31:36 | 11:37:37 | 11:43:48
SAT1 | 202 | 10:59:36 | 11:07:04 | 11:09:33 | 11:27:03 | 11:28:49 | 11:33:56 | 11:39:19
SAT1 | 233 | 10:59:36 | 11:07:05 | 11:09:29 | 11:27:04 | 11:28:46 | 11:33:30 | 11:38:25
SAT1 | 211 | 10:59:36 | 11:07:06 | 11:09:50 | 11:29:58 | 11:31:40 | 11:36:36 | 11:42:10
SAT1 | 236 | 10:59:36 | 11:07:07 | 11:09:35 | 11:27:13 | 11:28:56 | 11:33:37 | 11:39:12
SAT1 | 235 | 10:59:36 | 11:07:07 | 11:09:38 | 11:27:49 | 11:29:36 | 11:34:36 | 11:39:48
SAT1 | 254 | 10:59:36 | 11:07:08 | 11:09:27 | 11:27:04 | 11:28:54 | 11:34:00 | 11:39:22
SAT1 | 203 | 10:59:36 | 11:07:08 | 11:10:10 | 11:31:32 | 11:33:28 | 11:39:09 | 11:45:06
SAT1 | 226 | 10:59:36 | 11:07:09 | 11:09:48 | 11:27:48 | 11:29:49 | 11:34:53 | 11:40:00
SAT1 | 244 | 10:59:36 | 11:07:10 | 11:09:37 |  |  |  |  |  |  | 10 days, 0:00:00 | 10 days, 0:00:00
SAT1 | 223 | 10:59:36 | 11:07:10 | 11:09:46 | 11:28:41 | 11:30:33 | 11:35:50 | 11:41:20
SAT1 | 213 | 10:59:36 | 11:07:10 | 11:09:59 | 11:30:14 | 11:32:29 | 11:38:12 | 11:44:18
SAT1 | 231 | 10:59:36 | 11:07:13 | 11:09:50 | 11:28:00 | 11:29:46 | 11:34:54 | 11:40:03
SAT1 | 275 | 10:59:36 | 11:07:14 | 11:09:52 | 11:27:57 | 11:29:54 | 11:34:57 | 11:40:09
SAT1 | 255 | 10:59:36 | [NAME] | 11:10:07 | [NAME] | 11:29:49 | 11:35:49 | 11:41:31
SAT1 | 212 | 10:59:36 | 11:07:20 | 11:10:19 | 11:32:20 | 11:34:25 |  |  |  |  |  | 10 days, 0:00:00
SAT1 | 273 | 10:59:36 | 11:07:23 | 11:10:06 | 11:29:29 | 11:31:22 | 11:36:49 | 11:42:24
SAT1 | 210 | 10:59:36 | 11:07:25 | 11:10:11 | 11:30:08 | 11:32:08 | 11:37:58 | 11:44:02
SAT1 | 215 | 10:59:36 | 11:07:27 | 11:10:01 | 11:30:07 | 11:31:50 | 11:37:09 | 11:42:25
SAT1 | 284 | 10:59:36 | 11:07:28 | 11:10:12 | 11:30:40 | 11:32:38 | 11:38:29 | 11:44:41
SAT1 | 271 | 10:59:36 | 11:07:29 | 11:10:01 | 11:27:52 | 11:29:38 | 11:34:36 | 11:39:47
SAT1 | 250 | 10:59:36 | 11:07:30 | 11:10:22 | 11:28:58 | 11:30:54 | 11:36:10 | 11:41:31
SAT1 | 206 | 10:59:36 | 11:07:30 | 11:10:22 | 11:30:42 | 11:32:37 | 11:37:55 | 11:43:25
SAT1 | 241 | 10:59:36 | 11:07:31 | 11:10:09 | 11:27:52 | 11:29:44 | 11:35:03 | 11:40:26
SAT1 | 228 | 10:59:36 | 11:07:31 | 11:10:20 | 11:29:47 | 11:31:35 | 11:37:52 | 11:43:14
SAT1 | 204 | 10:59:36 | 11:07:31 | 11:10:24 | 11:32:05 | 11:34:28 | 11:41:17 | 11:48:28
SAT1 | 237 | 10:59:36 | 11:07:33 | 11:10:47 | 11:31:25 | 11:33:22 | 11:38:50 | 11:44:28
SAT1 | 208 | 10:59:36 | 11:07:33 | 11:10:29 | 11:32:06 | 11:34:32 | 11:40:08 | 11:45:59
SAT1 | 240 | 10:59:36 | 11:07:37 | 11:10:21 | 11:29:24 | 11:31:19 | 11:36:39 | 11:42:22
SAT1 | 242 | 10:59:36 | 11:07:52 | 11:10:55 | 11:30:55 | 11:33:07 | 11:39:10 | 11:45:04
SAT1 | 221 | 10:59:36 | 11:08:07 | 11:12:04 | 11:34:23 | 11:36:44 | 11:43:00 | 11:49:49
SAT1 | 216 | 10:59:36 | 11:08:17 | 11:11:34 | 11:32:58 | 11:35:02 | 11:40:57 | 11:47:16
SAT1 | 217 | 10:59:36 | 11:08:26 | 11:11:10 | 11:31:17 | 11:33:04 | 11:38:53 | 11:44:36
SAT1 | 272 | 10:59:36 | 11:08:33 | 11:11:41 | 11:32:39 | 11:34:48 | 11:40:33 | 11:46:27
SAT1 | 205 | 10:59:36 | 11:08:34 | 11:12:05 | 11:37:04 | 11:39:25 | [NAME] | 11:53:17
SAT1 | 209 | 10:59:36 | 11:08:49 | 11:11:44 | 11:31:10 | 11:32:57 | 11:38:16 | 11:43:52
SAT1 | 248 | 10:59:36 | 11:09:23 | 11:14:36 | 11:37:15 | 11:40:03 | 11:46:28 | 11:52:47
SAT1 | 207 | 10:59:36 | 11:09:25 | 11:12:31 | 11:36:13 | 11:38:30 | 11:44:48 | 11:51:26
SAT1 | 464 | 10:59:36 | 11:09:28 | 11:12:48 | 11:34:05 | 11:36:20 | 11:41:37 | 11:47:10
SAT1 | 256 | 10:59:36 | 11:09:37 | 11:16:04 | 11:39:24 | 11:45:26 |  |  |  |  |  | 10 days, 0:00:00
SAT1 | 249 | 10:59:36 | 11:09:39 | 11:12:46 | 11:32:25 | 11:34:18 | 11:40:02 | 11:46:13
SAT1 | 252 | 10:59:36 | 11:09:41 | 11:13:37 | 11:34:17 | 11:36:38 | 11:41:25 | 11:46:22
SAT1 | 463 | 10:59:36 | 11:10:18 | 11:14:24 | 11:35:34 | 11:37:55 | 11:43:30 | 11:49:09
SAT1 | 251 | 10:59:36 | 11:10:34 | 11:15:24 | 11:38:38 | 11:41:58 | 11:48:51 | 11:55:41
SAT1 | 230 | 10:59:36 | 11:10:56 | 11:15:29 | 11:36:49 | 11:39:27 | 11:45:37 | 11:51:53
SAT1 | 259 | 10:59:36 | 11:11:01 | 11:16:32 | 11:40:54 | 11:43:58 | 11:51:25 | 11:59:31
SAT1 | 218 | 10:59:36 | 11:11:11 | 11:16:06 | 11:42:45 | 11:45:31 | 11:53:48 | 12:01:56
SAT1 | 261 | 10:59:36 | 11:11:20 | 11:14:45 | 11:39:23 | 11:42:22 | 11:48:07 | 11:54:10
SAT1 | 253 | 10:59:36 | 11:13:06 | 11:19:33 | 11:54:11 | 11:57:15 | 12:04:10 | 12:10:59
SAT1 | 789 | 10:59:36 | 11:14:08 |  |  |  |  |  |  |  | 10 days, 0:00:00 | 10 days, 0:00:00
SAT1 | 222 | 10:59:36 | 11:15:46 | 11:22:25 | 11:52:48 | 11:56:45 | 12:06:20 | 12:15:43