Column A lists electricity usage for each half hour period. Columns B and C list half hour time periods per twenty four hours. Columns D and E list the actual half hours. Because the usage tariff is split I would like to be able to add the usage figures for the times between 00.30 and 04.30. I extracted the data in columns D and E using "TIMEVALUE". I have tried to do the addition by using "SUMIFS" but have failed miserably. Is this a process that I could do using my copy of Kutools and if so how please?
I have attached a 24 hours copy spreadsheet.