percentages

h58299

New Member
Joined
Apr 18, 2002
Messages
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.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
On 2002-04-19 11:42, h58299 wrote:
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
 
Upvote 0
On 2002-04-19 13:44, h58299 wrote:
On 2002-04-19 11:42, h58299 wrote:
works great /board/images/smiles/icon_smile.gif 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.
 
Upvote 0
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]
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top