ExcelBanter - Sum ? / Numbers with Text

Excellent Tom,
that worked great.. thanks for such a fast response..

I'm posting another question regarding this same data dump that I need to
do. Please check out...

"Tom Ogilvy" wrote:

copy the column to the next column
Select the new column and do

Edit=Replace
What: <spacehrs.<space
With: :

then
Edit=Replace
What: <spacemins.<space
With :

then
Edit =Replace
What: <spacesecs
With: <leave blank

This should convert all the entries to actual time values. Then you just
put a sumformula at the bottom and use a custom format like

hh" hrs. "mm" mins. "ss" secs"

(format=Cells=Number Tab, choose custom)

If they haven't been converted to time values, run Replace one more time
replaceing a single space with nothing. In the above <space represents a
single tap on the space bar

--
Regards,
Tom Ogilvy

"thom hoyle" wrote in message
...
I have a dump from out phone cost accounting system: It outputs for the
DURATION of the call in a column like this.

0 hrs. 2 mins. 44 secs.
0 hrs. 4 mins. 2 secs.
etc..
etc...

I need to sum the total of this data to output Total HRS, MINS, SEC, and
havn't got a clue on how to start.

thanks