I have a function which seems to work counting discharges between 23:00 and 06:00.
If i modify it to look at discharges between 06:00 and 12:00 it gives a false answer.
Using And instead of OR fixes it, but i don't know enough about excel to understand why this works.
I need to repeat the exercise for discharges between 12:00 to 16:00 and 16:00 to 23:00.
I have attached an example of the data.
Mike
Bookmarks