or do it in trimming and summing in one

=SUM(IF(B1:B10<"",--(TRIM(SUBSTITUTE(B1:B10,CHAR(160),"")))))

as an array formula

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sandy Mann" wrote in message
...
maryc,

Did you download the phone bill from the net? If so it may actually be
text. Try in another column:

=--TRIM(SUBSTITUTE(A1,CHAR(160),""))

Then if it turns it into numbers copy and Paste Special Values the new
data back over the original data and reformat the column as time.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"maryc" wrote in message
...
Thanks - have done as you suggested but end up with 0:00:00 - help!
--
maryc


"Bob Phillips" wrote:

=SUM( B:B)

and format the totals cell as [h]:mm:ss

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"maryc" wrote in message
...
Want to check my phone bill and need simple (please) instructions of
how
to
calculate total figure. Thanks
--
maryc