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

25 TO CITY SUN
 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
[NAME], Front Street stand 7 | - | - | - | 10:29:00 | 10:59:00 | 11:29:00 | 11:59:00 | 12:29:00 | 12:59:00 | 13:29:00 | 13:59:00 | 14:29:00 | 14:59:00 | 15:29:00 | 15:59:00 | 16:29:00 | 16:59:00 | - | - | - | - | - | - | - | -
[NAME], High Street, ASDA | - | - | - | 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 | - | - | - | - | - | - | - | -
High Street Avenue | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME], Sainsbury's | - | - | - | 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 | - | - | - | - | - | - | - | -
Portland Street | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
Thackeray's La, [NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
The Crescent | - | - | - | 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 | - | - | - | - | - | - | - | -
Littlegreen Road | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
[NAME] | - | - | - | 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 | - | - | - | - | - | - | - | -
Mapperley Shops | 09:14: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:48:00 | 18:18:00 | 18:48:00 | 19:18:00 | 20:03:00 | 21:03:00 | 22:03:00 | 23:03:00
[NAME] | 09:14: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:48:00 | 18:18:00 | 18:48:00 | 19:18:00 | 20:03:00 | 21:03:00 | 22:03:00 | 23:03:00
[NAME] | 09:15: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:49:00 | 18:19:00 | 18:49:00 | 19:19:00 | 20:04:00 | 21:04:00 | 22:04:00 | 23:04:00
Fernleigh Avenue | 09:15: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:49:00 | 18:19:00 | 18:49:00 | 19:19:00 | 20:04:00 | 21:04:00 | 22:04:00 | 23:04:00
Elmhurst Avenue | 09:16: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:50:00 | 18:20:00 | 18:50:00 | 19:20:00 | 20:05:00 | 21:05:00 | 22:05:00 | 23:05:00
[NAME], [NAME] | 09:17: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:51:00 | 18:21:00 | 18:51:00 | 19:21:00 | 20:06:00 | 21:06:00 | 22:06:00 | 23:06:00
Lascelles Avenue | 09:17: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:51:00 | 18:21:00 | 18:51:00 | 19:21:00 | 20:06:00 | 21:06:00 | 22:06:00 | 23:06:00
Hartington Avenue | 09:18: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:52:00 | 18:22:00 | 18:52:00 | 19:22:00 | 20:07:00 | 21:07:00 | 22:07:00 | 23:07:00
Bakewell Avenue | 09:18: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:52:00 | 18:22:00 | 18:52:00 | 19:22:00 | 20:07:00 | 21:07:00 | 22:07:00 | 23:07:00
[NAME], [NAME] | 09:19: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:53:00 | 18:23:00 | 18:53:00 | 19:23:00 | 20:08:00 | 21:08:00 | 22:08:00 | 23:08:00
Victoria Street | 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:53:00 | 18:23:00 | 18:53:00 | 19:23:00 | 20:08:00 | 21:08:00 | 22:08:00 | 23:08:00
Redland Grove | 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:54:00 | 18:24:00 | 18:54:00 | 19:24:00 | 20:09:00 | 21:09:00 | 22:09:00 | 23:09:00
Manor [NAME] | 09:21:00 | 09:48:00 | 10:18:00 | 10:48:00 | 11:18:00 | 11:48:00 | 12:18:00 | 12:48:00 | 13:18:00 | 13:48:00 | 14:18:00 | 14:48:00 | 15:18:00 | 15:48:00 | 16:18:00 | 16:48:00 | 17:18:00 | 17:54:00 | 18:24:00 | 18:54:00 | 19:24:00 | 20:09:00 | 21:09:00 | 22:09:00 | 23:09:00
[NAME] | 09:23: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:55:00 | 18:25:00 | 18:55:00 | 19:25:00 | 20:10:00 | 21:10:00 | 22:10:00 | 23:10:00
Tesco | 09:24: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:55:00 | 18:25:00 | 18:55:00 | 19:25:00 | 20:10:00 | 21:10:00 | 22:10:00 | 23:10:00
Southcliffe Road | 09:24: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:56:00 | 18:26:00 | 18:56:00 | 19:26:00 | 20:11:00 | 21:11:00 | 22:11:00 | 23:11:00
Chesterfield Street | 09:25:00 | 09:52:00 | 10:22:00 | 10:52:00 | 11:22:00 | 11:52:00 | 12:22:00 | 12:52:00 | 13:22:00 | 13:52:00 | 14:22:00 | 14:52:00 | 15:22:00 | 15:52:00 | 16:22:00 | 16:52:00 | 17:22:00 | 17:56:00 | 18:26:00 | 18:56:00 | 19:26:00 | 20:11:00 | 21:11:00 | 22:11:00 | 23:11:00
Forester Grove | 09:25:00 | 09:52:00 | 10:22:00 | 10:52:00 | 11:22:00 | 11:52:00 | 12:22:00 | 12:52:00 | 13:22:00 | 13:52:00 | 14:22:00 | 14:52:00 | 15:22:00 | 15:52:00 | 16:22:00 | 16:52:00 | 17:22:00 | 17:57:00 | 18:27:00 | 18:57:00 | 19:27:00 | 20:12:00 | 21:12:00 | 22:12:00 | 23:12:00
[NAME] | 09:26: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:57:00 | 18:27:00 | 18:57:00 | 19:27:00 | 20:12:00 | 21:12:00 | 22:12:00 | 23:12:00
Hooton Road | 09:27:00 | 09:54:00 | 10:24:00 | 10:54:00 | 11:24:00 | 11:54:00 | 12:24:00 | 12:54:00 | 13:24:00 | 13:54:00 | 14:24:00 | 14:54:00 | 15:24:00 | 15:54:00 | 16:24:00 | 16:54:00 | 17:24:00 | 17:58:00 | 18:28:00 | 18:58:00 | 19:28:00 | 20:13:00 | 21:13:00 | 22:13:00 | 23:13:00
Second Avenue | 09:28:00 | 09:55:00 | 10:25:00 | 10:55:00 | 11:25:00 | 11:55:00 | 12:25:00 | 12:55:00 | 13:25:00 | 13:55:00 | 14:25:00 | 14:55:00 | 15:25:00 | 15:55:00 | 16:25:00 | 16:55:00 | 17:25:00 | 17:59:00 | 18:29:00 | 18:59:00 | 19:29:00 | 20:14:00 | 21:14:00 | 22:14:00 | 23:14:00
[NAME], [NAME] | 09:29:00 | 09:56:00 | 10:26:00 | 10:56:00 | 11:26:00 | 11:56:00 | 12:26:00 | 12:56:00 | 13:26:00 | 13:56:00 | 14:26:00 | 14:56:00 | 15:26:00 | 15:56:00 | 16:26:00 | 16:56:00 | 17:26:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:15:00 | 21:15:00 | 22:15:00 | 23:15:00
Brentcliffe Avenue | 09:29:00 | 09:56:00 | 10:26:00 | 10:56:00 | 11:26:00 | 11:56:00 | 12:26:00 | 12:56:00 | 13:26:00 | 13:56:00 | 14:26:00 | 14:56:00 | 15:26:00 | 15:56:00 | 16:26:00 | 16:56:00 | 17:26:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:15:00 | 21:15:00 | 22:15:00 | 23:15:00
Comery Avenue | 09:30: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 | 18:01:00 | 18:31:00 | 19:01:00 | 19:31:00 | 20:16:00 | 21:16:00 | 22:16:00 | 23:16:00
[NAME] | 09:31:00 | 09:58:00 | 10:28:00 | 10:58:00 | 11:28:00 | 11:58:00 | 12:28:00 | 12:58:00 | 13:28:00 | 13:58:00 | 14:28:00 | 14:58:00 | 15:28:00 | 15:58:00 | 16:28:00 | 16:58:00 | 17:28:00 | 18:02:00 | 18:32:00 | 19:02:00 | 19:32:00 | 20:17:00 | 21:17:00 | 22:17:00 | 23:17:00
City College | 09:32:00 | 09:59:00 | 10:29:00 | 10:59:00 | 11:29:00 | 11:59:00 | 12:29:00 | 12:59:00 | 13:29:00 | 13:59:00 | 14:29:00 | 14:59:00 | 15:29:00 | 15:59:00 | 16:29:00 | 16:59:00 | 17:29:00 | 18:03:00 | 18:33:00 | 19:03:00 | 19:33:00 | 20:18:00 | 21:18:00 | 22:18:00 | 23:18:00
Randolph Street | 09:33: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:04:00 | 18:34:00 | 19:04:00 | 19:34:00 | 20:19:00 | 21:19:00 | 22:19:00 | 23:19:00
Carlton Rd, St. Matthias Rd | 09:34: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:05:00 | 18:35:00 | 19:05:00 | 19:35:00 | 20:20:00 | 21:20:00 | 22:20:00 | 23:20:00
St Chads Road | 09:34: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:05:00 | 18:35:00 | 19:05:00 | 19:35:00 | 20:20:00 | 21:20:00 | 22:20:00 | 23:20:00
Handel Street | 09:35: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:06:00 | 18:36:00 | 19:06:00 | 19:36:00 | 20:21:00 | 21:21:00 | 22:21:00 | 23:21:00
[NAME] | 09:36: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:07:00 | 18:37:00 | 19:07:00 | 19:37:00 | 20:22:00 | 21:22:00 | 22:22:00 | 23:22:00
Hockley | 09:37: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:08:00 | 18:38:00 | 19:08:00 | 19:38:00 | 20:23:00 | 21:23:00 | 22:23:00 | 23:23:00
Pryzm | 09:38: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:09:00 | 18:39:00 | 19:09:00 | 19:39:00 | 20:24:00 | 21:24:00 | 22:24:00 | 23:24:00
City, [NAME] V5 | 09:39: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:10:00 | 18:40:00 | 19:10:00 | 19:40:00 | 20:25:00 | 21:25:00 | 22:25:00 | 23:25:00
City, King Street K3 | 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:13:00 | 18:43:00 | 19:13:00 | 19:43:00 | 20:28:00 | 21:28:00 | 22:28:00 | 23:28:00