+ Reply to Thread
Results 1 to 6 of 6

importing time from pdf as table and calculating

  1. #1
    Registered User
    Join Date
    03-04-2006
    Posts
    3

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

  2. #2
    Guest

    Re: 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" <ludikris.2459za_1141474802.4409@excelforum-nospam.com> wrote in
    message news:ludikris.2459za_1141474802.4409@excelforum-nospam.com...
    >
    > 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
    >




  3. #3
    Registered User
    Join Date
    03-04-2006
    Posts
    3

    just scan it..

    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.

  4. #4
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    285

    importing time from pdf as table and calculating!

    hi!

    change the cell format to [h]:mm

    -via135



    Quote Originally Posted by 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 !!

  5. #5
    Sandy Mann
    Guest

    Re: 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
    sandymann2@mailinator.com
    Replace@mailinator.com with @tiscali.co.uk


    "ludikris" <ludikris.2459za_1141474802.4409@excelforum-nospam.com> wrote in
    message news:ludikris.2459za_1141474802.4409@excelforum-nospam.com...
    >
    > 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
    >




  6. #6
    Registered User
    Join Date
    03-04-2006
    Posts
    3
    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
    kris@ludikris.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1