Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Percentages (Excel 2000)

    Is there a way I can use a formula to calculate a percentage out of something other than 100? My organization uses a time sheet created in Excel, and I would like to look at the hours worked per week or month and determine the percent of time spent on certain tasks.

    Thanks in advance for any help.

    Amy

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percentages (Excel 2000)

    If the time spent on the task is in A1, and the total time is in B1, then the formula is: =A1/B1 and format the cell as a percent.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •