Spreadsheet: 718730d1613315164-help-with-conditional-formatting-based-on-current-time-timetable
Sheet: 27 TO CITY SUN

27 TO CITY SUN
 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27
Carlton, Elmhurst Avenue | 06:04:00 | 07:04:00 | 08:04:00 | 09:04:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:06:00 | 18:36:00 | 19:06:00 | 19:36:00 | 20:36:00 | 21:36:00 | 22:36:00
Marwood Road | 06:04:00 | 07:04:00 | 08:04:00 | 09:04:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:06:00 | 18:36:00 | 19:06:00 | 19:36:00 | 20:36:00 | 21:36:00 | 22:36:00
Huckerby's Field | 06:05:00 | 07:05:00 | 08:05:00 | 09:05:00 | 09:31:00 | 10:01:00 | 10:31:00 | 11:01:00 | 11:31:00 | 12:01:00 | 12:31:00 | 13:01:00 | 13:31:00 | 14:01:00 | 14:31:00 | 15:01:00 | 15:31:00 | 16:01:00 | 16:31:00 | 17:01:00 | 17:31:00 | 18:07:00 | 18:37:00 | 19:07:00 | 19:37:00 | 20:37:00 | 21:37:00 | 22:37:00
Coningswath Rd Bottom | 06:05:00 | 07:05:00 | 08:05:00 | 09:05:00 | 09:32:00 | 10:02:00 | 10:32:00 | 11:02:00 | 11:32:00 | 12:02:00 | 12:32:00 | 13:02:00 | 13:32:00 | 14:02:00 | 14:32:00 | 15:02:00 | 15:32:00 | 16:02:00 | 16:32:00 | 17:02:00 | 17:32:00 | 18:07:00 | 18:37:00 | 19:07:00 | 19:37:00 | 20:37:00 | 21:37:00 | 22:37:00
Belper Avenue | 06:06:00 | 07:06:00 | 08:06:00 | 09:06:00 | 09:32:00 | 10:02:00 | 10:32:00 | 11:02:00 | 11:32:00 | 12:02:00 | 12:32:00 | 13:02:00 | 13:32:00 | 14:02:00 | 14:32:00 | 15:02:00 | 15:32:00 | 16:02:00 | 16:32:00 | 17:02:00 | 17:32:00 | 18:08:00 | 18:38:00 | 19:08:00 | 19:38:00 | 20:38:00 | 21:38:00 | 22:38:00
Alpine Crescent | 06:06:00 | 07:06:00 | 08:06:00 | 09:06:00 | 09:33:00 | 10:03:00 | 10:33:00 | 11:03:00 | 11:33:00 | 12:03:00 | 12:33:00 | 13:03:00 | 13:33:00 | 14:03:00 | 14:33:00 | 15:03:00 | 15:33:00 | 16:03:00 | 16:33:00 | 17:03:00 | 17:33:00 | 18:08:00 | 18:38:00 | 19:08:00 | 19:38:00 | 20:38:00 | 21:38:00 | 22:38:00
Cemetery | 06:07:00 | 07:07:00 | 08:07:00 | 09:07:00 | 09:34:00 | 10:04:00 | 10:34:00 | 11:04:00 | 11:34:00 | 12:04:00 | 12:34:00 | 13:04:00 | 13:34:00 | 14:04:00 | 14:34:00 | 15:04:00 | 15:34:00 | 16:04:00 | 16:34:00 | 17:04:00 | 17:34:00 | 18:09:00 | 18:39:00 | 19:09:00 | 19:39:00 | 20:39:00 | 21:39:00 | 22:39:00
[NAME] | 06:08:00 | 07:08:00 | 08:08:00 | 09:08:00 | 09:35:00 | 10:05:00 | 10:35:00 | 11:05:00 | 11:35:00 | 12:05:00 | 12:35:00 | 13:05:00 | 13:35:00 | 14:05:00 | 14:35:00 | 15:05:00 | 15:35:00 | 16:05:00 | 16:35:00 | 17:05:00 | 17:35:00 | 18:10:00 | 18:40:00 | 19:10:00 | 19:40:00 | 20:40:00 | 21:40:00 | 22:40:00
Tesco | 06:09:00 | 07:09:00 | 08:09:00 | 09:09:00 | 09:36:00 | 10:06:00 | 10:36:00 | 11:06:00 | 11:36:00 | 12:06:00 | 12:36:00 | 13:06:00 | 13:36:00 | 14:06:00 | 14:36:00 | 15:06:00 | 15:36:00 | 16:06:00 | 16:36:00 | 17:06:00 | 17:36:00 | 18:10:00 | 18:40:00 | 19:10:00 | 19:40:00 | 20:40:00 | 21:40:00 | 22:40:00
Southcliffe Road | 06:09:00 | 07:09:00 | 08:09:00 | 09:09:00 | 09:36:00 | 10:06:00 | 10:36:00 | 11:06:00 | 11:36:00 | 12:06:00 | 12:36:00 | 13:06:00 | 13:36:00 | 14:06:00 | 14:36:00 | 15:06:00 | 15:36:00 | 16:06:00 | 16:36:00 | 17:06:00 | 17:36:00 | 18:11:00 | 18:41:00 | 19:11:00 | 19:41:00 | 20:41:00 | 21:41:00 | 22:41:00
Chesterfield Street | 06:10:00 | 07:10:00 | 08:10:00 | 09:10:00 | 09:37:00 | 10:07:00 | 10:37:00 | 11:07:00 | 11:37:00 | 12:07:00 | 12:37:00 | 13:07:00 | 13:37:00 | 14:07:00 | 14:37:00 | 15:07:00 | 15:37:00 | 16:07:00 | 16:37:00 | 17:07:00 | 17:37:00 | 18:11:00 | 18:41:00 | 19:11:00 | 19:41:00 | 20:41:00 | 21:41:00 | 22:41:00
Forester Grove | 06:10:00 | 07:10:00 | 08:10:00 | 09:10:00 | 09:37:00 | 10:07:00 | 10:37:00 | 11:07:00 | 11:37:00 | 12:07:00 | 12:37:00 | 13:07:00 | 13:37:00 | 14:07:00 | 14:37:00 | 15:07:00 | 15:37:00 | 16:07:00 | 16:37:00 | 17:07:00 | 17:37:00 | 18:12:00 | 18:42:00 | 19:12:00 | 19:42:00 | 20:42:00 | 21:42:00 | 22:42:00
[NAME] | 06:11:00 | 07:11:00 | 08:11:00 | 09:11:00 | 09:38:00 | 10:08:00 | 10:38:00 | 11:08:00 | 11:38:00 | 12:08:00 | 12:38:00 | 13:08:00 | 13:38:00 | 14:08:00 | 14:38:00 | 15:08:00 | 15:38:00 | 16:08:00 | 16:38:00 | 17:08:00 | 17:38:00 | 18:12:00 | 18:42:00 | 19:12:00 | 19:42:00 | 20:42:00 | 21:42:00 | 22:42:00
Hooton Road | 06:12:00 | 07:12:00 | 08:12:00 | 09:12:00 | 09:39:00 | 10:09:00 | 10:39:00 | 11:09:00 | 11:39:00 | 12:09:00 | 12:39:00 | 13:09:00 | 13:39:00 | 14:09:00 | 14:39:00 | 15:09:00 | 15:39:00 | 16:09:00 | 16:39:00 | 17:09:00 | 17:39:00 | 18:13:00 | 18:43:00 | 19:13:00 | 19:43:00 | 20:43:00 | 21:43:00 | 22:43:00
Second Avenue | 06:13:00 | 07:13:00 | 08:13:00 | 09:13:00 | 09:40:00 | 10:10:00 | 10:40:00 | 11:10:00 | 11:40:00 | 12:10:00 | 12:40:00 | 13:10:00 | 13:40:00 | 14:10:00 | 14:40:00 | 15:10:00 | 15:40:00 | 16:10:00 | 16:40:00 | 17:10:00 | 17:40:00 | 18:14:00 | 18:44:00 | 19:14:00 | 19:44:00 | 20:44:00 | 21:44:00 | 22:44:00
[NAME], [NAME] | 06:14:00 | 07:14:00 | 08:14:00 | 09:14:00 | 09:41:00 | 10:11:00 | 10:41:00 | 11:11:00 | 11:41:00 | 12:11:00 | 12:41:00 | 13:11:00 | 13:41:00 | 14:11:00 | 14:41:00 | 15:11:00 | 15:41:00 | 16:11:00 | 16:41:00 | 17:11:00 | 17:41:00 | 18:15:00 | 18:45:00 | 19:15:00 | 19:45:00 | 20:45:00 | 21:45:00 | 22:45:00
Brentcliffe Avenue | 06:14:00 | 07:14:00 | 08:14:00 | 09:14:00 | 09:41:00 | 10:11:00 | 10:41:00 | 11:11:00 | 11:41:00 | 12:11:00 | 12:41:00 | 13:11:00 | 13:41:00 | 14:11:00 | 14:41:00 | 15:11:00 | 15:41:00 | 16:11:00 | 16:41:00 | 17:11:00 | 17:41:00 | 18:15:00 | 18:45:00 | 19:15:00 | 19:45:00 | 20:45:00 | 21:45:00 | 22:45:00
Comery Avenue | 06:15:00 | 07:15:00 | 08:15:00 | 09:15:00 | 09:42:00 | 10:12:00 | 10:42:00 | 11:12:00 | 11:42:00 | 12:12:00 | 12:42:00 | 13:12:00 | 13:42:00 | 14:12:00 | 14:42:00 | 15:12:00 | 15:42:00 | 16:12:00 | 16:42:00 | 17:12:00 | 17:42:00 | 18:16:00 | 18:46:00 | 19:16:00 | 19:46:00 | 20:46:00 | 21:46:00 | 22:46:00
[NAME] | 06:16:00 | 07:16:00 | 08:16:00 | 09:16:00 | 09:43:00 | 10:13:00 | 10:43:00 | 11:13:00 | 11:43:00 | 12:13:00 | 12:43:00 | 13:13:00 | 13:43:00 | 14:13:00 | 14:43:00 | 15:13:00 | 15:43:00 | 16:13:00 | 16:43:00 | 17:13:00 | 17:43:00 | 18:17:00 | 18:47:00 | 19:17:00 | 19:47:00 | 20:47:00 | 21:47:00 | 22:47:00
City College | 06:17:00 | 07:17:00 | 08:17:00 | 09:17:00 | 09:44:00 | 10:14:00 | 10:44:00 | 11:14:00 | 11:44:00 | 12:14:00 | 12:44:00 | 13:14:00 | 13:44:00 | 14:14:00 | 14:44:00 | 15:14:00 | 15:44:00 | 16:14:00 | 16:44:00 | 17:14:00 | 17:44:00 | 18:18:00 | 18:48:00 | 19:18:00 | 19:48:00 | 20:48:00 | 21:48:00 | 22:48:00
Randolph Street | 06:18:00 | 07:18:00 | 08:18:00 | 09:18:00 | 09:45:00 | 10:15:00 | 10:45:00 | 11:15:00 | 11:45:00 | 12:15:00 | 12:45:00 | 13:15:00 | 13:45:00 | 14:15:00 | 14:45:00 | 15:15:00 | 15:45:00 | 16:15:00 | 16:45:00 | 17:15:00 | 17:45:00 | 18:19:00 | 18:49:00 | 19:19:00 | 19:49:00 | 20:49:00 | 21:49:00 | 22:49:00
Carlton Rd, St. Matthias Rd | 06:19:00 | 07:19:00 | 08:19:00 | 09:19:00 | 09:46:00 | 10:16:00 | 10:46:00 | 11:16:00 | 11:46:00 | 12:16:00 | 12:46:00 | 13:16:00 | 13:46:00 | 14:16:00 | 14:46:00 | 15:16:00 | 15:46:00 | 16:16:00 | 16:46:00 | 17:16:00 | 17:46:00 | 18:20:00 | 18:50:00 | 19:20:00 | 19:50:00 | 20:50:00 | 21:50:00 | 22:50:00
St Chads Road | 06:19:00 | 07:19:00 | 08:19:00 | 09:19:00 | 09:46:00 | 10:16:00 | 10:46:00 | 11:16:00 | 11:46:00 | 12:16:00 | 12:46:00 | 13:16:00 | 13:46:00 | 14:16:00 | 14:46:00 | 15:16:00 | 15:46:00 | 16:16:00 | 16:46:00 | 17:16:00 | 17:46:00 | 18:20:00 | 18:50:00 | 19:20:00 | 19:50:00 | 20:50:00 | 21:50:00 | 22:50:00
Handel Street | 06:20:00 | 07:20:00 | 08:20:00 | 09:20:00 | 09:47:00 | 10:17:00 | 10:47:00 | 11:17:00 | 11:47:00 | 12:17:00 | 12:47:00 | 13:17:00 | 13:47:00 | 14:17:00 | 14:47:00 | 15:17:00 | 15:47:00 | 16:17:00 | 16:47:00 | 17:17:00 | 17:47:00 | 18:21:00 | 18:51:00 | 19:21:00 | 19:51:00 | 20:51:00 | 21:51:00 | 22:51:00
[NAME] | 06:21:00 | 07:21:00 | 08:21:00 | 09:21:00 | 09:49:00 | 10:19:00 | 10:49:00 | 11:19:00 | 11:49:00 | 12:19:00 | 12:49:00 | 13:19:00 | 13:49:00 | 14:19:00 | 14:49:00 | 15:19:00 | 15:49:00 | 16:19:00 | 16:49:00 | 17:19:00 | 17:49:00 | 18:22:00 | 18:52:00 | 19:22:00 | 19:52:00 | 20:52:00 | 21:52:00 | 22:52:00
Hockley | 06:22:00 | 07:22:00 | 08:22:00 | 09:22:00 | 09:50:00 | 10:20:00 | 10:50:00 | 11:20:00 | 11:50:00 | 12:20:00 | 12:50:00 | 13:20:00 | 13:50:00 | 14:20:00 | 14:50:00 | 15:20:00 | 15:50:00 | 16:20:00 | 16:50:00 | 17:20:00 | 17:50:00 | 18:23:00 | 18:53:00 | 19:23:00 | 19:53:00 | 20:53:00 | 21:53:00 | 22:53:00
Pryzm | 06:23:00 | 07:23:00 | 08:23:00 | 09:23:00 | 09:51:00 | 10:21:00 | 10:51:00 | 11:21:00 | 11:51:00 | 12:21:00 | 12:51:00 | 13:21:00 | 13:51:00 | 14:21:00 | 14:51:00 | 15:21:00 | 15:51:00 | 16:21:00 | 16:51:00 | 17:21:00 | 17:51:00 | 18:24:00 | 18:54:00 | 19:24:00 | 19:54:00 | 20:54:00 | 21:54:00 | 22:54:00
City, [NAME] V5 | 06:24:00 | 07:24:00 | 08:24:00 | 09:24:00 | 09:53:00 | 10:23:00 | 10:53:00 | 11:23:00 | 11:53:00 | 12:23:00 | 12:53:00 | 13:23:00 | 13:53:00 | 14:23:00 | 14:53:00 | 15:23:00 | 15:53:00 | 16:23:00 | 16:53:00 | 17:23:00 | 17:53:00 | 18:25:00 | 18:55:00 | 19:25:00 | 19:55:00 | 20:55:00 | 21:55:00 | 22:55:00
City, King Street K3 | 06:27:00 | 07:27:00 | 08:27:00 | 09:27:00 | 09:57:00 | 10:27:00 | 10:57:00 | 11:27:00 | 11:57:00 | 12:27:00 | 12:57:00 | 13:27:00 | 13:57:00 | 14:27:00 | 14:57:00 | 15:27:00 | 15:57:00 | 16:27:00 | 16:57:00 | 17:27:00 | 17:57:00 | 18:28:00 | 18:58:00 | 19:28:00 | 19:58:00 | 20:58:00 | 21:58:00 | 22:58:00