Spreadsheet: 888353d1738844606-sort-number-of-hours-into-particular-zones-periods-of-time-example-2
Sheet: Sheet1

Town | Equipment series number | State | Date | Start Time | End Time | Reason
X | 1 | USED | Mon, 01-Jan-2024 | 00:00 | 01:00 | XYZ
X | 1 | USED | Mon, 01-Jan-2024 | 01:00 | 06:00 | XYZ
X | 1 | USED | Mon, 01-Jan-2024 | 06:00 | 10:30 | XYZ
X | 1 | USED | Mon, 01-Jan-2024 | 15:00 | 16:45 | XYZ
X | 1 | USED | Tue, 02-Jan-2024 | 07:00 | 09:00 | XYZ
X | 1 | USED | Wed, 03-Jan-2024 | 06:00 | 09:00 | XYZ
X | 1 | USED | Wed, 03-Jan-2024 | 10:00 | 16:00 | XYZ
X | 1 | USED | Fri, 05-Jan-2024 | 06:00 | 07:00 | XYZ
X | 1 | USED | Fri, 05-Jan-2024 | 07:00 | 18:00 | XYZ
X | 1 | USED | Sat, 06-Jan-2024 | 08:00 | 19:00 | XYZ
X | 1 | USED | Sat, 06-Jan-2024 | 19:00 | 23:45 | XYZ
X | 1 | USED | Sun, 07-Jan-2024 | 00:00 | 09:00 | XYZ
X | 1 | USED | Sun, 07-Jan-2024 | 10:00 | 19:00 | XYZ
X | 1 | USED | Mon, 08-Jan-2024 | 05:00 | 07:00 | XYZ
X | 1 | USED | Mon, 08-Jan-2024 | 07:00 | 16:00 | XYZ
X | 1 | USED | Mon, 08-Jan-2024 | 16:00 | 17:00 | XYZ
X | 1 | USED | Mon, 08-Jan-2024 | 17:00 | 18:00 | XYZ
X | 1 | USED | Tue, 09-Jan-2024 | 07:00 | 13:00 | XYZ
Y | 1 | USED | Tue, 09-Jan-2024 | 13:00 | 15:00 | XYZ
Y | 1 | USED | Tue, 09-Jan-2024 | 15:00 | 15:45 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 07:00 | 09:00 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 13:45 | 15:00 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 15:00 | 16:00 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 16:00 | 16:30 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 17:00 | 18:30 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 19:00 | 23:00 | XYZ
Y | 22 | USED | Wed, 10-Jan-2024 | 23:00 | 23:45 | XYZ
Y | 22 | USED | Thu, 11-Jan-2024 | 00:00 | 06:00 | XYZ
Y | 22 | USED | Thu, 11-Jan-2024 | 06:00 | 09:00 | XYZ
Y | 15 | USED | Thu, 11-Jan-2024 | 13:00 | 16:00 | XYZ
Y | 15 | USED | Sat, 13-Jan-2024 | 08:00 | 12:00 | XYZ
Y | 15 | USED | Sat, 13-Jan-2024 | 12:00 | 13:00 | XYZ
Y | 15 | USED | Sat, 13-Jan-2024 | 13:00 | 13:30 | XYZ
Y | 15 | USED | Sat, 13-Jan-2024 | 13:30 | 17:00 | XYZ
Y | 15 | USED | Sun, 14-Jan-2024 | 08:00 | 09:00 | XYZ
Y | 15 | USED | Sun, 14-Jan-2024 | 09:00 | 10:00 | XYZ
Y | 15 | USED | Sun, 14-Jan-2024 | 10:00 | 19:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 07:00 | 08:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 08:00 | 09:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 09:00 | 15:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 15:00 | 16:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 17:00 | 18:00 | XYZ
Y | 15 | USED | Mon, 15-Jan-2024 | 18:00 | 19:00 | XYZ
Y | 15 | USED | Tue, 16-Jan-2024 | 05:00 | 07:30 | XYZ
Y | 15 | USED | Tue, 16-Jan-2024 | 07:30 | 09:00 | XYZ
Y | 15 | USED | Tue, 16-Jan-2024 | 09:00 | 15:00 | XYZ
Y | 15 | USED | Wed, 17-Jan-2024 | 06:00 | 07:00 | XYZ
Y | 15 | USED | Wed, 17-Jan-2024 | 07:00 | 08:00 | XYZ
Y | 15 | USED | Wed, 17-Jan-2024 | 08:00 | 09:00 | XYZ
Y | 8 | USED | Wed, 17-Jan-2024 | 17:00 | 18:30 | XYZ
Y | 8 | USED | Wed, 17-Jan-2024 | 18:30 | 23:45 | XYZ
Y | 8 | USED | Thu, 18-Jan-2024 | 00:00 | 05:00 | XYZ
Y | 8 | USED | Thu, 18-Jan-2024 | 05:00 | 07:00 | XYZ
Y | 8 | USED | Thu, 18-Jan-2024 | 07:00 | 08:00 | XYZ
Y | 8 | USED | Thu, 18-Jan-2024 | 08:00 | 09:00 | XYZ
Y | 8 | USED | Thu, 18-Jan-2024 | 09:00 | 17:30 | XYZ
Y | 8 | USED | Fri, 19-Jan-2024 | 06:00 | 09:00 | XYZ
Y | 8 | USED | Fri, 19-Jan-2024 | 11:00 | 12:30 | XYZ
Y | 8 | USED | Sat, 20-Jan-2024 | 11:15 | 23:45 | XYZ
Y | 8 | USED | Sun, 21-Jan-2024 | 00:00 | 08:00 | XYZ
Y | 8 | USED | Sun, 21-Jan-2024 | 08:00 | 18:00 | XYZ
Y | 8 | USED | Mon, 22-Jan-2024 | 06:00 | 07:00 | XYZ
Y | 8 | USED | Mon, 22-Jan-2024 | 07:00 | 08:00 | XYZ
Y | 8 | USED | Tue, 23-Jan-2024 | 06:30 | 08:00 | XYZ
Y | 8 | USED | Tue, 23-Jan-2024 | 08:00 | 09:00 | XYZ
Y | 8 | USED | Tue, 23-Jan-2024 | 09:00 | 16:00 | XYZ
Y | 8 | USED | Wed, 24-Jan-2024 | 05:00 | 06:30 | XYZ
Y | 8 | USED | Wed, 24-Jan-2024 | 06:30 | 07:00 | XYZ
Y | 8 | USED | Wed, 24-Jan-2024 | 07:00 | 09:00 | XYZ
Y | 8 | USED | Wed, 24-Jan-2024 | 17:00 | 18:00 | XYZ
Y | 8 | USED | Wed, 24-Jan-2024 | 20:00 | 21:00 | XYZ
Y | 8 | USED | Thu, 25-Jan-2024 | 06:30 | 13:00 | XYZ
Y | 8 | USED | Thu, 25-Jan-2024 | 15:00 | 17:00 | XYZ
Y | 8 | USED | Thu, 25-Jan-2024 | 19:00 | 20:00 | XYZ
Y | 8 | USED | Thu, 25-Jan-2024 | 20:00 | 21:00 | XYZ
Y | 8 | USED | Thu, 25-Jan-2024 | 21:00 | 23:45 | XYZ
Y | 8 | USED | Fri, 26-Jan-2024 | 00:00 | 06:00 | XYZ
Y | 8 | USED | Fri, 26-Jan-2024 | 06:30 | 07:00 | XYZ
Y | 8 | USED | Fri, 26-Jan-2024 | 15:00 | 20:00 | XYZ
Y | 8 | USED | Sat, 27-Jan-2024 | 08:00 | 20:00 | XYZ
Y | 8 | USED | Sat, 27-Jan-2024 | 20:00 | 23:45 | XYZ
Y | 8 | USED | Sun, 28-Jan-2024 | 00:00 | 15:30 | XYZ
Y | 8 | USED | Sun, 28-Jan-2024 | 18:00 | 19:00 | XYZ
Y | 8 | USED | Mon, 29-Jan-2024 | 07:00 | 09:00 | XYZ
Y | 8 | USED | Tue, 30-Jan-2024 | 06:00 | 16:00 | XYZ
Y | 8 | USED | Wed, 31-Jan-2024 | 05:00 | 06:00 | XYZ
Y | 8 | USED | Wed, 31-Jan-2024 | 06:00 | 08:00 | XYZ
Y | 45 | USED | Wed, 31-Jan-2024 | 08:00 | 09:00 | XYZ
V | 45 | USED | Wed, 31-Jan-2024 | 09:00 | 13:00 | XYZ
V | 45 | USED | Wed, 31-Jan-2024 | 13:00 | 18:00 | XYZ
V | 45 | USED | Wed, 31-Jan-2024 | 18:00 | 18:30 | XYZ