SUMIF between time range Monday to Friday.

[Yamezz]

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:
SUMIF(A1:A1000,{between 7am and 9pm Monday to Friday},B1:B1000)

Any help is much appreciated.
Thanks guys.

 

[JazzSP8]

How is the value in Column A formatted?

Is it a number or is it text?

Can you please provide an example of it?

 

[Yamezz]

The cell shows 16/02/2018 0:45
but when selected, the formula bar shows 16/02/2018 12:45:00 AM
The cell format shows d/mm/yyyy h:mm

Thanks.

 

[steve the fish]

Try a sumproduct:

=SUMPRODUCT(--(WEEKDAY($A$1:$A$100,2)<6),--(MOD($A$1:$A$100,1)>=7/24),--(MOD($A$1:$A$100,1)<=21/24),$B$1:$B$100)

 

[Yamezz]

I think that's done it Steve. Thanks.