percentage on columns

[911]

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

[ConneXionLost]

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:

=B2/SUM($B$2:$B$24)

Ensure cell C2 is formatted as "percent", then autofill it down to cell C24.

Cheers,