sum text&numbers
Thanks!
"Rick Rothstein" a scris:
To put the entry in the cell as text...
="late "&TEXT(RIGHT(A1,8)+RIGHT(B1,8),"[hh]:mm:ss")
To put the entry in the cell as a real time value...
=RIGHT(A1,8)+RIGHT(B1,8)
and Custom Format the cell using this...
"late "[hh]:mm:ss
--
Rick (MVP - Excel)
"puiuluipui" wrote in message
...
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.
|