sum text&numbers
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.
|