Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 10:19 PM.


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