SUMPRODUCT >24H00

[an]

Hello!

I would like to know if is possible, based in next
formulae:

=SUMPRODUCT(--(colorindex(D1921;TRUE)=3);D1921)

to calc values where >24H00.

Thanks in advance.
an

 

[Frank Kabel]

Hi
and in which column is this data?

 

[an]

Column D
Block D1921
Thanks.
an

-----Original Message-----
Hi
and in which column is this data?

.

 

[Frank Kabel]

Hi
thoug not quite sure how you storedf these numbers try:
=SUMPRODUCT(--(colorindex(D1921;TRUE)=3);--(D1921>24);D1921)

or
=SUMPRODUCT(--(colorindex(D1921;TRUE)=3);--(D1921>TIME(24;0;0));D19
21)

 

[an]

Thanks for your reply.

The 2nd formulae return, for example:
15:00+10:00+5:00 = 6:00
One day + 6:00 (30:00 = 24:00 + 6:00)

an