Time Increments (summing value) - need help wih formula

Hi

Firstly, you will have to convert all your entries in the range A16:A72 into real time entries. Basically, select A16, edit, and then save, and you should note that the entry formats to a number in time format, and right aligns.

Then in say L1 enter the formula

=SUMPRODUCT(--($A$16:$A$72>=J3),--($A$16:$A$72<=K3),($B$16:$B$72))+SUMPRODUCT(--($A$16:$A$72>=J3),--($A$16:$A$72<=K3),($C$16:$C$72))

and copy down to L50.

See how that goes.

rylo

Hi Rylo,
Thank you for your response, it doesn't seem to work?
The Data on column A to E is extracted/pasted as text, is there a way where we don't have to manipulate the raw data?

Hi

OK, try this, based on the example file.

F16:

=TIMEVALUE(A16)

Copy down to F72
L3:

=SUMPRODUCT(--($F$16:$F$72>=J3),--($F$16:$F$72<=K3),($B$16:$B$72))+SUMPRODUCT(--($F$16:$F$72>=J3),--($F$16:$F$72<=K3),($C$16:$C$72))

Copy down to L50.

This will bring back the totals of 16 and 71 in cells L18 and L19 as per your first post.

rylo

Rylo, thank you so much for your help with this.