Thanks:  0
Likes:  0

1. 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. ="3 7/8"/4 formatted as 0.00% is 96.88%

3. [quote]works great cheers

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

4. [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. [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. 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]

User Tag List

Posting Permissions

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