Spreadsheet: 888403d1738877752-sort-number-of-hours-into-particular-zones-periods-of-time-example-jz82_2
Sheet: Sheet2

 | Station | Equipment series number | State | Date | Month | Monday-Friday / Weekend | Start Time | End Time | Time grouped | Reason | Number of hours equipment is used for |  | 00:00:00 | 06:00:00 | 12:00:00 | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00 | 12:00:00 | 18:00:00 | 1900-01-01 00:00:00
ORIGINAL RECORD | X | 12 | USED | Sat, 06-Jan-2024 | January | Weekend | 08:00 | 19:00 |  | XYZ
SPLIT INTO PERIOD OF TIMES |  |  |  |  |  |  | 08:00:00 | 12:00:00 | 06:00- 12:00
 |  |  |  |  |  |  | 12:00:00 | 18:00:00 | 12:00-18:00
 |  |  |  |  |  |  | 18:00:00 | 19:00:00 | 18:00-00:00 |  | 01:00:00
ORIGINAL RECORD | X | 12 | USED | Sun, 07-Jan-2024 | January | Weekend | 10:00 | 15:00:00 |  | XYZ
SPLIT INTO PERIOD OF TIMES |  |  |  |  |  |  | 10:00:00 | 12:00:00 | 06:00-12:00
 |  |  |  |  |  |  | 12:00:00 | 15:00:00 | 12:00-18:00
 | X | 12 | USED | Sun, 14-Jan-2024 | January | Weekend | 01:00:00 | 16:00:00 |  | XYZ
 |  |  |  |  |  |  | 01:00:00 | 06:00:00 | 00:00-06:00
 |  |  |  |  |  |  | 06:00:00 | 12:00:00 | 06:00-12:00
 |  |  |  |  |  |  | 12:00:00 | 16:00:00 | 12:00-18:00
 | X | 12 | USED | Mon, 15-Jan-2024 | January | Monday-Friday | 18:00 | 23:45:00 |  | XYZ
 |  |  |  |  |  |  | 18:00:00 | 00:00:00 | 18:00-00:00 |  | 05:45:00
 | X | 12 | USED | Fri, 09-Feb-2024 | February | Monday-Friday | 16:00 | 19:00 |  | XYZ
 | X | 12 | USED | Sun, 18-Feb-2024 | February | Weekend | 16:30 | 19:00 |  | XYZ
 | X | 12 | USED | Sun, 25-Feb-2024 | February | Weekend | 14:45 | 19:00 |  | XYZ
 | X | 12 | USED | Mon, 26-Feb-2024 | February | Monday-Friday | 17:15 | 19:00 |  | XYZ
 | X | 12 | USED | Wed, 28-Feb-2024 | February | Monday-Friday | 16:30 | 19:00 |  | XYZ
 | X | 12 | USED | Thu, 29-Feb-2024 | February | Monday-Friday | 09:00 | 19:00 |  | XYZ
 | X | 12 | USED | Thu, 07-Mar-2024 | March | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 12 | USED | Mon, 15-Apr-2024 | April | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 12 | USED | Wed, 17-Apr-2024 | April | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 12 | USED | Fri, 19-Apr-2024 | April | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 12 | USED | Wed, 24-Apr-2024 | April | Monday-Friday | 16:30 | 19:00 |  | XYZ
 | X | 12 | USED | Thu, 25-Apr-2024 | April | Monday-Friday | 15:00 | 19:00 |  | XYZ
 | X | 2 | USED | Fri, 26-Apr-2024 | April | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 2 | USED | Sun, 28-Apr-2024 | April | Weekend | 00:00 | 19:00 |  | XYZ
 | X | 2 | USED | Thu, 02-May-2024 | May | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 2 | USED | Mon, 06-May-2024 | May | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Sat, 11-May-2024 | May | Weekend | 12:00 | 19:00 |  | XYZ
 | X | 2 | USED | Wed, 15-May-2024 | May | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Fri, 31-May-2024 | May | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Wed, 05-Jun-2024 | June | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Sun, 09-Jun-2024 | June | Weekend | 16:00 | 19:00 |  | XYZ
 | X | 2 | USED | Wed, 12-Jun-2024 | June | Monday-Friday | 15:00 | 19:00 |  | XYZ
 | X | 2 | USED | Mon, 17-Jun-2024 | June | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 2 | USED | Wed, 19-Jun-2024 | June | Monday-Friday | 15:00 | 19:00 |  | XYZ
 | X | 2 | USED | Thu, 20-Jun-2024 | June | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Tue, 25-Jun-2024 | June | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 2 | USED | Tue, 02-Jul-2024 | July | Monday-Friday | 15:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 03-Jul-2024 | July | Monday-Friday | 15:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 15-Jul-2024 | July | Monday-Friday | 13:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 22-Jul-2024 | July | Monday-Friday | 16:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 31-Jul-2024 | July | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Sat, 03-Aug-2024 | August | Weekend | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 05-Aug-2024 | August | Monday-Friday | 17:15 | 19:00 |  | XYZ
 | X | 55 | USED | Thu, 08-Aug-2024 | August | Monday-Friday | 16:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 12-Aug-2024 | August | Monday-Friday | 17:45 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 14-Aug-2024 | August | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 28-Aug-2024 | August | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Thu, 29-Aug-2024 | August | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 02-Sep-2024 | September | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 04-Sep-2024 | September | Monday-Friday | 07:00 | 19:00 |  | XYZ
 | X | 55 | USED | Mon, 16-Sep-2024 | September | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 18-Sep-2024 | September | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | X | 55 | USED | Wed, 09-Oct-2024 | October | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 55 | USED | Sat, 26-Oct-2024 | October | Weekend | 17:00 | 19:00 |  | XYZ
 | Y | 55 | USED | Mon, 28-Oct-2024 | October | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Thu, 31-Oct-2024 | October | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Fri, 01-Nov-2024 | November | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Mon, 04-Nov-2024 | November | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Sat, 09-Nov-2024 | November | Weekend | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Sun, 10-Nov-2024 | November | Weekend | 13:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Sat, 23-Nov-2024 | November | Weekend | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Mon, 25-Nov-2024 | November | Monday-Friday | 09:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Mon, 09-Dec-2024 | December | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Fri, 13-Dec-2024 | December | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Fri, 20-Dec-2024 | December | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Thu, 26-Dec-2024 | December | Monday-Friday | 14:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Tue, 31-Dec-2024 | December | Monday-Friday | 17:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Mon, 15-Jan-2024 | January | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Sat, 16-Mar-2024 | March | Weekend | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Mon, 25-Mar-2024 | March | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Tue, 26-Mar-2024 | March | Monday-Friday | 18:00 | 19:00 |  | XYZ
 | Y | 14 | USED | Tue, 02-Apr-2024 | April | Monday-Friday | 18:00 | 19:00 |  | XYZ