please help me with percentage calulations...thanks!

[pedie]

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5888" width=161><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><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: 121pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=161 height=17>

Month​

</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 71pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=95>

Downtime​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

Jan​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

6:26:00​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

Feb​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

6:03:00​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

March​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

7:39:00​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

April​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

9:18:00​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

May​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

16:42:00​

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>

June​

</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">

53:33:07​

</TD></TR></TBODY></TABLE>

This is how the downtime for tech looks like.
It has decreased in feb and then after that it has been continously increasing after that till june...
I was suppose to show in percentage how this increase and decrease has been happening....

Please advise how should i go about this....my bose wants this done soon....for presentation..thanks everyone for helping!!!

 

[Special-K99]

in C1
=B2/B1*100

and copy down as far as B5

 

[scottylad2]

Excel Workbook
	I	J	K
3	jan	06:26:00
4	feb	06:03:00	-5.96%
5	mar	06:26:00	6.34%
6	apr	06:26:00	0.00%
7	may	16:42:00	159.59%
8	jun	53:33:07	220.67%
Sheet1

Formula in K3 dragged down

 

[pedie]

Is this how i show percentage comparasion in months??? please check my table below:

<TABLE style="WIDTH: 186pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=246 border=0><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" span=3 width=82><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD class=xl67 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black 2pt double; BORDER-LEFT: black 2pt double; WIDTH: 62pt; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #948b54" width=82 height=19>

Month​

</TD><TD class=xl67 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black 2pt double; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #948b54" width=82>

Downtime​

</TD><TD class=xl68 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black 2pt double; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #948b54" width=82>

% Increase​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

Jan​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

6.26​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

Feb​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

6.03​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

96.3​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

March​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

7.39​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

122.6​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

April​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

9.18​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

124.2​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

May​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

16.32​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

177.8​

</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD class=xl69 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black 2pt double; BORDER-BOTTOM: black 2pt double; HEIGHT: 14.25pt; BACKGROUND-COLOR: #c5be97" height=19>

June​

</TD><TD class=xl70 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

53.33​

</TD><TD class=xl71 style="BORDER-RIGHT: black 2pt double; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 2pt double; BACKGROUND-COLOR: #c5be97">

326.8​

</TD></TR></TBODY></TABLE>

How do i show this is PPT?

 

[Norie]

Pedie

Where did you get your percentage figures from?

What is it you want to represent?

If you simply want a percentage increase/decrease month by month then you should be able to use the formulas posted already.

How to show it in PPT?

Well I think you'd want to use a chart for that, just like you would in Excel.

 

[pedie]

ScottyLad2, thank alot...I think that was GREAT!!!!

 

[scottylad2]

No problem