Please help me with % calcualtion...thanks!

[pedie]

Time spent on Learning was increased from <TABLE style="WIDTH: 52pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=69 border=0><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: #8db4e3" width=69 height=17>6.26</TD></TR></TBODY></TABLE>in Jan to
<TABLE style="WIDTH: 52pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=69 border=0><COLGROUP><COL style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523" width=69><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 52pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=69 height=17>53.33</TD></TR></TBODY></TABLE>in july 2010
in Hrs.

how do I calculaet the increased percentage?
Formula with explaination will be great!

Thank you all!

 

[pagrender]

Percentage increase is calculated as (New-Old)/Old.

Or in this case, (53.33-6.26)/6.26 or 752%

 

[BBrandt]

I think you're looking for something like this:

=(([FONT=Arial]53.33-6.26)/6.26)*100[/FONT]

...or in a more general form (replace red and blue phrases with references to the cells containing the desired data)...

=(([FONT=Arial][COLOR=red]Second Value[/COLOR] - [COLOR=blue]First Value[/COLOR])/[COLOR=blue]First Value[/COLOR])*100[/FONT]

Explanation:
1) Find the difference between the two numbers (in this case 53.33 - 6.26 = 47.07)
2) Take the difference (47.07) and divide by the original number (47.07/6.26 = 7.519)
3) Multiply the result by 100: 7.519*100 = 751.9% = the percent increase from 6.26 to 53.33

 

[pedie]

Great thanks!!!

Thanks alot!

 

[BBrandt]

No problem. Also, that same formula works for percent decrease too with no modifications, so it will still work in the event that the second value is less than the first. Glad we could help.