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