percentages

h58299 · Apr 19th, 2002, 12:25 PM

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.

Mark W. · Apr 19th, 2002, 12:32 PM

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

h58299 · Apr 19th, 2002, 12:42 PM

[quote]works great

cheers

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

h58299 · Apr 19th, 2002, 02:44 PM

[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

Mark W. · Apr 19th, 2002, 02:55 PM

[quote]
On 2002-04-19 13:44, h58299 wrote:
[quote]
On 2002-04-19 11:42, h58299 wrote:

Quote:

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.

h58299 · Apr 19th, 2002, 03:03 PM

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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 12:25 PM	#1
h58299 New Member Join Date: Apr 2002 Posts: 15	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.

Apr 19th, 2002, 12:32 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	="3 7/8"/4 formatted as 0.00% is 96.88%

Apr 19th, 2002, 12:42 PM	#3
h58299 New Member Join Date: Apr 2002 Posts: 15	[quote]works great cheers [ This Message was edited by: h58299 on 2002-04-19 14:48 ]

Apr 19th, 2002, 02:44 PM	#4
h58299 New Member Join Date: Apr 2002 Posts: 15	[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

Apr 19th, 2002, 03:03 PM	#6
h58299 New Member Join Date: Apr 2002 Posts: 15	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]