kwh

Good Day, I have a large spreadsheet with more than 76,000 rows. In this spreadsheet I have 3 columns, namely Date, Time and kWh. The kWh column gives half hourly electricity consumption values based on the Date and Time interval. I need to roll up the date and time columns into a 24 hour...

I have the output of my solar inverter giving me column A with the date and time of the measurement and column B with the solar system production in kWh. I would like to use a function to get the kWh during the period 7am-9pm Monday to Friday. I guess I need the correct syntax for this...

I'm trying to find a way I can identify a value where a column and row meet. In this example, I am trying to find the value in the column where SHQ on the top row meets BP in the first column, the result I would expect to see is 24. Similarly, if I wanted to look for TT and HA I would expect...

Hi guys, I posted a question regarding this recently but I don't think I worded it quite correctly and after some consideration have come up with a clearer (wordy) way of trying to calculate something which would be awesome if someone could convert to excel language for me! I am trying to...

Here is a small sample below. I have about 12,000 rows of energy usage data by the hour per day. I would like to know what my average kWh usage is at a specific hour per month. I think I need to use some kind of index/match sum function, but I'm not really sure how to do it. I also played...

Hi there, I am new to VBA and have used the macro recorder to record the process I am trying to achieve. The issue I am having is that when the length of the column changes my Macro is stuck to the same column length (range) I used for the original graph on the Macro Recorder. Effectively I...