Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-01-2010, 04:12 AM
911 911 is offline percentage on columns Windows XP percentage on columns Office 2003
Novice
percentage on columns
 
Join Date: Sep 2010
Posts: 1
911 is on a distinguished road
Default percentage on columns

well,i have 1 column with each hour of the day,so it looks like this:


0:00 - 1:00
1:00 - 2:00
2:00 - 3:00
3:00 - 4:00
4:00 - 5:00
5:00 - 6:00
6:00 - 7:00
7:00 - 8:00
8:00 - 9:00


......................


and so on ,it ends at 23:00 - 24:00 (or 0:00).this is the column A.
on the right column (that's column B)i'll put some numbers.i'll tell you what this means.I play an online game,and i want to keep track of how many times i get espioonaged at one given hour.so let's say i get espionaged from 12:00 to 13:00 for 4 times,and from 16:00 to 17:00 for 3 times.i'll fill up the cells with 4 for 12:00 - 13:00 and 3 for 16:00 - 17:00.and so on....i hope you get it
what i want to do is to make the next column(column C)a percentage column.So,based on how many times i get espionaged at any given hour,i want the column C to tell me the likehood of when i will be espionaged at a give hour.So let,s say i get espionaged 5 times (I write 5 on column B,next to hour 16:00)at hour 16:00,and i never get espionaged at any other hours,just at hour 16:00.So that means the likehood that i'll get espionaged at hour 16:00 is 100% percent.If i get espionaged once at hour 14:00 and once at 16:00,that will be 50% chance for both hours,assuming i never get espionaged at any other hours,except those.oh and if you sum up all the percentages on column C,it must NOT exceed 100%,I do not want 2 cells in column C that say 100%.Remember,all cells summed up must be exactly 100%.
Those were just some examples to make you understand what i want.
is there any formula or anything that would do what I want to do?

pls help me,i really need it )

thx in advance

911
Reply With Quote
  #2  
Old 09-01-2010, 09:28 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline percentage on columns Windows XP percentage on columns Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Assuming you have your times listed in the range A2:A24, and your count of espionage hits in B2:B24.

In cell C2, paste this formula:

Code:
=B2/SUM($B$2:$B$24)
Ensure cell C2 is formatted as "percent", then autofill it down to cell C24.

Cheers,
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage on columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Footnotes and Columns toll_booth Word 0 06-02-2010 01:35 PM
percentage on columns insert 2 columns in the right PKTEE Word 1 10-24-2009 05:55 AM
percentage on columns Independent columns jdthelen Word 2 09-17-2009 09:34 PM
percentage on columns SUMMING TWO COLUMNS LOGISTICS1 Excel 1 04-18-2006 06:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft