Try this formula...

=IF(OR(A1={"","No"},B1={"","No"}),"","late
"&TEXT(RIGHT(A1,8)+RIGHT(B1,8),"[hh]:mm:ss"))

--
Rick (MVP - Excel)


"puiuluipui" wrote in message
...
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!

"Sheeloo" a scris:

Try this in C1
=RIGHT(A1,8)+RIGHT(B1,8)
and format the cell as [h]:mm:ss

"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.