Spreadsheet: 718678d1613295183-help-with-conditional-formatting-based-on-current-time-time-format
Sheet: Sheet1

Current time: | 07:10:00
 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
Holyoake Road | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
[NAME], Front Street stand 7 | - | - | - | 06:44:00 | - | 07:02:00 | - | 07:18:00 | - | 07:36:00 | - | 07:56:00 | - | 08:16:00 | - | 08:36:00 | 08:56:00
[NAME], High Street, ASDA | - | - | - | 06:45:00 | - | 07:03:00 | - | 07:19:00 | - | 07:37:00 | - | 07:57:00 | - | 08:17:00 | - | 08:37:00 | 08:57:00
High Street Avenue | - | - | - | 06:45:00 | - | 07:03:00 | - | 07:19:00 | - | 07:37:00 | - | 07:57:00 | - | 08:17:00 | - | 08:37:00 | 08:57:00
[NAME] | - | - | - | 06:46:00 | - | 07:04:00 | - | 07:20:00 | - | 07:38:00 | - | 07:58:00 | - | 08:18:00 | - | 08:38:00 | 08:58:00
[NAME], Sainsbury's | - | - | - | 06:46:00 | - | 07:04:00 | - | 07:20:00 | - | 07:38:00 | - | 07:58:00 | - | 08:18:00 | - | 08:38:00 | 08:58:00
Portland Street | - | - | - | 06:47:00 | - | 07:05:00 | - | 07:21:00 | - | 07:39:00 | - | 07:59:00 | - | 08:19:00 | - | 08:39:00 | 08:59:00
[NAME] | - | - | - | 06:48:00 | - | 07:06:00 | - | 07:22:00 | - | 07:40:00 | - | 08:00:00 | - | 08:20:00 | - | 08:40:00 | 09:00:00
Thackeray's La, [NAME] | - | - | - | 06:50:00 | - | 07:08:00 | - | 07:24:00 | - | 07:43:00 | - | 08:03:00 | - | 08:23:00 | - | 08:43:00 | 09:03:00
[NAME] | - | - | - | 06:50:00 | - | 07:08:00 | - | 07:24:00 | - | 07:43:00 | - | 08:03:00 | - | 08:23:00 | - | 08:43:00 | 09:03:00
[NAME] | - | - | - | 06:51:00 | - | 07:09:00 | - | 07:25:00 | - | 07:44:00 | - | 08:04:00 | - | 08:24:00 | - | 08:44:00 | 09:04:00
The Crescent | - | - | - | 06:51:00 | - | 07:09:00 | - | 07:25:00 | - | 07:44:00 | - | 08:04:00 | - | 08:24:00 | - | 08:44:00 | 09:04:00
Littlegreen Road | - | - | - | 06:52:00 | - | 07:10:00 | - | 07:26:00 | - | 07:45:00 | - | 08:05:00 | - | 08:25:00 | - | 08:45:00 | 09:05:00
[NAME] | - | - | - | 06:52:00 | - | 07:11:00 | - | 07:27:00 | - | 07:46:00 | - | 08:06:00 | - | 08:26:00 | - | 08:46:00 | 09:06:00
[NAME] | - | - | - | 06:53:00 | - | 07:12:00 | - | 07:28:00 | - | 07:47:00 | - | 08:07:00 | - | 08:27:00 | - | 08:47:00 | 09:07:00
Mapperley Shops | 05:46:00 | 06:13:00 | 06:33:00 | 06:55:00 | 07:05:00 | 07:14:00 | 07:22:00 | 07:30:00 | 07:40:00 | 07:49:00 | 07:59:00 | 08:09:00 | 08:20:00 | 08:29:00 | 08:39:00 | 08:49:00 | 09:09:00
[NAME] | 05:46:00 | 06:14:00 | 06:34:00 | 06:56:00 | 07:06:00 | 07:15:00 | 07:23:00 | 07:31:00 | 07:41:00 | 07:50:00 | 08:00:00 | 08:10:00 | 08:21:00 | 08:30:00 | 08:40:00 | 08:50:00 | 09:10:00
[NAME] | 05:47:00 | 06:14:00 | 06:34:00 | 06:56:00 | 07:06:00 | 07:15:00 | 07:23:00 | 07:31:00 | 07:41:00 | 07:50:00 | 08:00:00 | 08:10:00 | 08:21:00 | 08:30:00 | 08:40:00 | 08:50:00 | 09:10:00
Fernleigh Avenue | 05:47:00 | 06:15:00 | 06:35:00 | 06:57:00 | 07:07:00 | 07:16:00 | 07:24:00 | 07:32:00 | 07:42:00 | 07:51:00 | 08:01:00 | 08:11:00 | 08:22:00 | 08:31:00 | 08:41:00 | 08:51:00 | 09:11:00
Elmhurst Avenue | 05:47:00 | 06:15:00 | 06:35:00 | 06:57:00 | 07:07:00 | 07:16:00 | 07:24:00 | 07:32:00 | 07:42:00 | 07:52:00 | 08:02:00 | 08:12:00 | 08:22:00 | 08:32:00 | 08:42:00 | 08:52:00 | 09:12:00
[NAME], [NAME] | 05:48:00 | 06:16:00 | 06:36:00 | 06:58:00 | 07:08:00 | 07:17:00 | 07:25:00 | 07:33:00 | 07:43:00 | 07:53:00 | 08:03:00 | 08:13:00 | 08:23:00 | 08:33:00 | 08:43:00 | 08:53:00 | 09:13:00
Lascelles Avenue | 05:48:00 | 06:16:00 | 06:36:00 | 06:58:00 | 07:08:00 | 07:17:00 | 07:25:00 | 07:34:00 | 07:44:00 | 07:54:00 | 08:04:00 | 08:14:00 | 08:24:00 | 08:34:00 | 08:44:00 | 08:54:00 | 09:14:00
Hartington Avenue | 05:49:00 | 06:17:00 | 06:37:00 | 06:59:00 | 07:09:00 | 07:18:00 | 07:26:00 | 07:35:00 | 07:45:00 | 07:55:00 | 08:05:00 | 08:15:00 | 08:25:00 | 08:35:00 | 08:45:00 | 08:55:00 | 09:15:00
Bakewell Avenue | 05:49:00 | 06:18:00 | 06:38:00 | 07:00:00 | 07:10:00 | 07:19:00 | 07:27:00 | 07:36:00 | 07:46:00 | 07:56:00 | 08:06:00 | 08:16:00 | 08:26:00 | 08:36:00 | 08:46:00 | 08:56:00 | 09:16:00
[NAME], [NAME] | 05:50:00 | 06:19:00 | 06:39:00 | 07:01:00 | 07:11:00 | 07:20:00 | 07:28:00 | 07:37:00 | 07:47:00 | 07:57:00 | 08:07:00 | 08:17:00 | 08:27:00 | 08:37:00 | 08:47:00 | 08:57:00 | 09:17:00
Victoria Street | 05:50:00 | 06:19:00 | 06:39:00 | 07:02:00 | 07:12:00 | 07:21:00 | 07:29:00 | 07:38:00 | 07:48:00 | 07:58:00 | 08:08:00 | 08:18:00 | 08:28:00 | 08:38:00 | 08:48:00 | 08:58:00 | 09:18:00
Redland Grove | 05:51:00 | 06:20:00 | 06:40:00 | 07:03:00 | 07:13:00 | 07:22:00 | 07:30:00 | 07:39:00 | 07:49:00 | 07:59:00 | 08:09:00 | 08:19:00 | 08:29:00 | 08:39:00 | 08:49:00 | 08:59:00 | 09:19:00