I view my rogers phone bill online and it allows me to save it as a pdf
that I can access later

From what I read in these NG's if you downloaded the bill from the net then
it will most likely have spaces - probably non-breaking hard spaces
CHAR(160).

Try changing the format of the cells to General - if the *times* really are
times then you will get a decimal nmber less then 1

If it doesn't change to a number then try using
=VALUE(SUBSTITUTE(A1,CHAR(160),"")) in a cell formatted as General.

--
HTH

Sandy

with @tiscali.co.uk


"ludikris" wrote in
message ...

Hi,

I view my rogers phone bill online and it allows me to save it as a pdf
that I can access later... I then import the date using the table select
function but when I try to sum the table, I get zeros.

for example..

10:00
22:10
16:00

=sum(a1:a3) the formula
00:00 what I see
48:10 what I should get.

Can someone help me solve this ?

the .xls is attached in zip format...

Thanks !!


+-------------------------------------------------------------------+
|Filename: rogers test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4416 |
+-------------------------------------------------------------------+

--
ludikris
------------------------------------------------------------------------
ludikris's Profile:
http://www.excelforum.com/member.php...o&userid=32140
View this thread: http://www.excelforum.com/showthread...hreadid=518973