Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: percentages

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to have excel to convert fractions to percentages, I need to get the percentage of items that have been done in a certain time eg, if I get 4 done which will take 10hrs and the shift is 10hrs then that is 100% but if I only get 3 & 7/8 or any other combination how can I put this into excel and have it tell me what percentage of work has been done within the allotted time. I can work it out on paper by turning the amount into an improper fraction but I wanted to use excel if I could, do you think this can be done.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ="3 7/8"/4 formatted as 0.00% is 96.88%

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [quote]works great cheers


    [ This Message was edited by: h58299 on 2002-04-19 14:48 ]

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [quote]
    On 2002-04-19 11:42, h58299 wrote:
    [quote]works great cheers
    On 2002-04-19 11:25, h58299 wrote:
    sorry to bother you again but how do i put it in a worksheet so i type the fractions in one cell and it gives me the answer in another. Thanks again

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [quote]
    On 2002-04-19 13:44, h58299 wrote:
    [quote]
    On 2002-04-19 11:42, h58299 wrote:
    works great [img]/board/images/smiles/icon_smile.gif[/img] cheers
    On 2002-04-19 11:25, h58299 wrote:
    sorry to bother you again but how do i put it in a worksheet so i type the fractions in one cell and it gives me the answer in another. Thanks again
    No problem. Just enter 3 7/8 in a cell (e.g., A1), 4 in another (e.g., B1) and use =A1/B1.

  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks
    No problem. Just enter 3 7/8 in a cell (e.g., A1), 4 in another (e.g., B1) and use =A1/B1.
    [/quote]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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