importing time from pdf as table and calculating

[ludikris]

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

 

[Guest]

Hi

I would guess you have got leading or trailing blanks in the cells - which
means that Excel does not recognise it as a time. I doubt anyone on this
forum would open your attachment to check it, however.

Andy.

 

[ludikris]

I dont blame you all for being a bit wary but, scan the attachment
before you open it to be safe and then try and get it to sum.

I really need to be able to check my cell phone times because I think
they are too high.

 

[via135]

hi!

change the cell format to [h]:mm

-via135

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

 

[Sandy Mann]

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
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[ludikris]

Hi all,

I still have not been able to do this.. can someone use my attachment
and email it back to me ?

I'd really appreciate it..

Chris
(e-mail address removed)