I have this sheet (which is generated by my Solar Inverter)
Which produces the following (2 columns)
date-time kWh-generated
for example
2022/11/09 17:00 13.29
in a 5 or 6 min interval for a whole week (this attached sheet is only a small part of it (total lines original sheet is over 2000))
Now I am looking for the highest number kWh on a day to day basis
(I marked it in green on the sheet)
BUT
it must ignore numbers from 7:00pm till 7:00am so only pick the highest number for that day in the period from 7am - 6:xxPM as Solar is producing from approx 7am onwards till 5-6pm only.
Is this possible with VBA?
TiA
Bookmarks