sum between two times with a particular date | formula required

[Mr.Karr]

Hello,

I have a table from where I need to pull or sum data that occurs between two times. Kindly refer to the sample file attached & provide a formula.

Thanks,
Kar

 

[Mr.Karr]

A small twist here. Can we able to compose an excel formula to calculate data for an hour, if 9 AM is mentioned, the formula should capture data between 8AM and 9AM.

If 10AM is in cell, it should calculate data between 9AM and 10AM

 

[bosco_yip]

In H2, enter formula :

=SUMIFS(C:C,A:A,F2,B:B,">="&(G2-TIME(1,0,0)),B:B,"<="&G2)

Regards
Bosco

 

[Mr.Karr]

excellent. Thank you @bosco_yip