Spreadsheet: 74945d1275485378-solved-journey-length-if-function-example-journey-length
Sheet: Point A

Time In | TYPE | COLOUR | REG | Time Out
07:00:00 | LGV | SILVER | QWE1
07:02:00 | LGV | WHITE | QWE2
07:03:00 | LGV | WHITE | QWE3
07:04:00 | LGV | WHITE | QWE4
07:04:00 | LGV | WHITE | QWE5
07:04:00 | BUS |  | [NAME]
07:05:00 | BUS |  | QWE7
07:05:00 | BUS |  | [NAME]
07:05:00 | BUS | YELLOW | QWE9
07:06:00 | CAR | BLACK | QWE10
07:06:00 | BUS |  | QWE11
07:06:00 | LGV | BLUE | QWE12
07:06:00 | CAR | YELLOW | QWE13
07:07:00 | CAR | SILVER | QWE14
07:07:00 | BUS |  | QWE15
07:07:00 | LGV | WHITE | QWE16
07:08:00 | LGV | SILVER | QWE17
07:08:00 | LGV | WHITE | QWE18
07:10:00 | LGV | WHITE | QWE19
07:10:00 | LGV | WHITE | QWE20
07:11:00 | LGV | WHITE | QWE21
07:12:00 | LGV | WHITE | QWE22
07:12:00 | BUS |  | QWE23
07:14:00 | BUS |  | [NAME]
07:16:00 | BUS | BLACK | QWE25
07:17:00 | HGV | WHITE | QWE26
07:17:00 | LGV | SILVER | QWE27
07:18:00 | CAR | RED | QWE28
07:18:00 | CAR | BLUE | QWE29
07:18:00 | BUS | YELLOW | QWE30
07:19:00 | LGV | SILVER | QWE31
07:21:00 | BUS |  | QWE32
07:21:00 | BUS |  | QWE33
07:22:00 | CAR | SILVER | QWE34
07:22:00 | LGV | SILVER | QWE35
07:22:00 | LGV | RED | QWE36
07:22:00 | CAR | BLACK | QWE37
07:23:00 | BUS |  | QWE38
07:23:00 | BUS |  | QWE39
07:23:00 | CAR | RED | QWE40
07:24:00 | BUS |  | QWE41
07:24:00 | LGV | WHITE | [NAME]
07:24:00 | BUS |  | QWE43
07:25:00 | BUS |  | QWE44
07:25:00 | LGV | BLUE | QWE45
07:26:00 | LGV | BLUE | QWE46
07:26:00 | LGV | WHITE | QWE47
07:27:00 | HGV | WHITE | QWE48
07:28:00 | HGV | WHITE | QWE49
07:28:00 | BUS |  | QWE50
07:28:00 | CAR | SILVER | QWE51
07:29:00 | BUS |  | QWE52
07:29:00 | CAR |  | QWE53
07:29:00 | BUS |  | QWE54
07:30:00 | CAR | RED | QWE55
07:30:00 | CAR | BLUE | QWE56
07:31:00 | BUS |  | QWE57
07:31:00 | BUS |  | QWE58
07:32:00 | LGV | WHITE | QWE59
07:32:00 | CAR | YELLOW | QWE60
07:33:00 | CAR | GREEN | QWE61
07:34:00 | CAR | WHITE | QWE62
07:35:00 | TAXI | YELLOW | QWE63
07:36:00 | BUS |  | [NAME]
07:36:00 | BUS |  | QWE65
07:37:00 | CAR | BLACK | [NAME]
07:37:00 | CAR | BLUE | QWE67
07:37:00 | BUS |  | QWE68
07:38:00 | LGV | BLUE | [NAME]
07:38:00 | BUS |  | QWE70
07:39:00 | CAR | BLACK | QWE71
07:39:00 | CAR | BLUE | QWE72
07:39:00 | CAR | BLACK | QWE73
07:40:00 | BUS |  | QWE74
07:41:00 | LGV | SILVER | QWE75
07:41:00 | BUS |  | QWE76
07:41:00 | BUS |  | QWE77
07:41:00 | BUS |  | QWE78
07:42:00 | BUS |  | QWE79
07:43:00 | BUS |  | QWE80
07:44:00 | CAR | BLUE | QWE81
07:44:00 | CAR | BLUE | QWE82
07:45:00 | CAR | BLUE | QWE83
07:45:00 | CAR | RED | QWE84
07:46:00 | HGV |  | QWE85
07:46:00 | CAR | RED | QWE86
07:46:00 |  | SILVER | QWE87
07:47:00 | LGV | WHITE | QWE88
07:47:00 | LGV | WHITE | QWE89
07:47:00 | LGV | WHITE | QWE90
07:48:00 | CAR | GREEN | QWE91
07:48:00 | BUS |  | QWE92
07:49:00 | CAR | SILVER | QWE93
07:49:00 | CAR | RED | QWE94
07:49:00 | LGV | WHITE | QWE95
07:50:00 | BUS |  | QWE96
07:51:00 | BUS |  | QWE97
07:51:00 | CAR | BLUE | QWE98
07:51:00 |  | SILVER | QWE99
07:52:00 |  |  | QWE100
07:52:00 | LGV |  | QWE101
07:52:00 | CAR | BLACK | QWE102
07:53:00 | LGV | WHITE | QWE103
07:53:00 | CAR | BLUE | QWE104
07:53:00 | BUS |  | QWE105
07:53:00 | BUS |  | QWE106
07:53:00 | CAR | SILVER | QWE107
07:53:00 | CAR | RED | QWE108
07:54:00 | LGV | WHITE | QWE109
07:55:00 | LGV | WHITE | [NAME]
07:55:00 | BUS |  | QWE111
07:56:00 | CAR | RED | QWE112
07:56:00 | BUS |  | QWE113
07:57:00 | BUS |  | QWE114
07:57:00 | CAR | GREEN | [NAME]
07:57:00 | CAR | GREEN | QWE116
07:58:00 | CAR | BLACK | QWE117
07:58:00 | CAR | SILVER | QWE118
07:58:00 | LGV | SILVER | QWE119
07:59:00 | LGV | WHITE | QWE120
08:00:00 | LGV | WHITE | QWE121
08:01:00 | LGV | WHITE | QWE122
08:01:00 | LGV | WHITE | QWE123
08:02:00 | BUS |  | QWE124
08:02:00 | HGV |  | QWE125
08:02:00 | LGV | WHITE | QWE126
08:02:00 | CAR | SILVER | QWE127
08:03:00 | BUS |  | QWE128
08:03:00 | LGV | BLACK | QWE129
08:04:00 | BUS |  | QWE130
08:04:00 | CAR | BLACK | QWE131
08:04:00 | LGV | BLACK | QWE132
08:04:00 | LGV | WHITE | QWE133
08:04:00 | BUS |  | QWE134
08:05:00 | CAR | BLACK | QWE135
08:06:00 | BUS |  | [NAME]
08:06:00 | CAR | SILVER | QWE137
08:07:00 | BUS |  | [NAME]
08:08:00 | BUS | YELLOW | QWE139
08:08:00 | LGV | WHITE | QWE140
08:08:00 | LGV | BLACK | QWE141
08:08:00 | BUS |  | QWE142
08:09:00 | BUS |  | QWE143
08:09:00 | LGV | WHITE | QWE144
08:10:00 | BUS |  | QWE145
08:10:00 | CAR | BLACK | QWE146
08:11:00 | BUS |  | QWE147
08:11:00 | LGV | WHITE | QWE148
08:12:00 | BUS |  | QWE149
08:12:00 | CAR | BLACK | QWE150
08:12:00 | BUS |  | QWE151