importing time from pdf as table and calculating
 

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

importing time from pdf as table and calculating
 

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

importing time from pdf as table and calculating
 

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.


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

importing time from pdf as table and calculating
 

hi!

change the cell format to [h]:mm

-via135



ludikris Wrote:
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 !!


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

importing time from pdf as table and calculating
 

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

importing time from pdf as table and calculating
 

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



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