solar

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...

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...

Hi there! Debut post =) I'm trying to do some calculations but I can only see a long manual way round so looking for a much easier way! What I'm trying to do is work out how much solar energy (kWh) has been generated since the installation date of some solar panels. I have a bunch of dates in...

Hi all, I have a very difficult situation and hope you can help. I need to save excel into text. Here are the things I have tried 1. Save is space delaminated file: Problem is it is limited to 250 character per line so lots of the data is lost 2. Save as tab delaminated file: it will generate...