Hi, i have one more problem. your code it's working but someytimes i have a
blank cell or a cell containing "NO", and it gives me #VALUE!

Can the code ignore blank cells or cells containing "NO"?

Thanks!

"Shane Devenshire" a scris:

Hi,

Try this:

=SUMPRODUCT(--SUBSTITUTE(A1:A2,"late ",""))

assuming your two enteries are in A1:A2. On the plus side of this fomula is
that is will work for 100 cells just as well as 2. Format the cell to time.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"puiuluipui" wrote:

Hi, how can i sum 2 cells that contains each, text and numbers.
Ex:

A B
late 00:00:05 late 00:02:48


(late 00:00:05)+(late 00:02:48)=late 00:02:53
or
(late 00:00:05)+(late 00:02:48)=00:02:53


Thanks in advance.