Adjust formula to calculate time

[janiss]

Hi
Trying to calculate the time in minutes over a range
B10:AF10 is the range but if the num 17:00 then i dont want to include in the sum. is it possible?

=SUM(IF(B10:AF10<TIME(17,0,0),B10:AF10)

or should i change the range calculation? For cell
EX: cell B10

=IF(B8>TIME(17,0,0),0,TIME(17,0,0)-B8)

can i change it to also reflect 0 for 17:00? But i have no idea how to change it to reflect 0 mins if it is.

Will appreciate any help available
If my Question is confusing pls tell me, I'll admend it.

Thanks in advance

[DonkeyOte]

A sample file often helps but if you're saying 17:00+ should be ignored then:

Please Login or Register  to view this content.

remember to format the result cell as [h]:mm so as to show cumulative hours

[janiss]

Thank you.
It worked.

A sample file often helps but if you're saying 17:00+ should be ignored then:

Please Login or Register  to view this content.

remember to format the result cell as [h]:mm so as to show cumulative hours