Sum ? / Numbers with Text

[Guest]

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

 

[Tom Ogilvy]

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

Edit=>Replace
What: <space>hrs.<space>
With: :

then
Edit=>Replace
What: <space>mins.<space>
With :

then
Edit =>Replace
What: <space>secs
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

 

[Guest]

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