SUM weekday hours - CF time format ?

Hi,

I have this CF formula :

Please Login or Register  to view this content.

It should calculate working hours within weekdays from rows E6:BM6 where sum of time intervals are (for a day), and If exceeds 56 hours a week It should highlight all cells within that week.

Problem is that cells where SUM should be performed are all formatted as time (hh:mm), so this formula probaly doesn't recognize 56 as time.

I tried with "56:00" in formula, but still nothing. How can I fix that, maybe SUMPRODUCT is not correct ??

This formula works If there are regular numbers in rows E6:BM6, but I need time formats

Thanks for help !!

Thanks to both of you,

It works, how could I miss that, so easy