+ Reply to Thread
Results 1 to 7 of 7

% Of Time Spent Over A Week...

  1. #1
    Registered User
    Join Date
    05-13-2007
    Posts
    4

    % Of Time Spent Over A Week...

    Sorry if my title isn't very clear, I'll try and explain what I need help with...

    Bascally, I have a spreadseet with the days of the week at the top, and each hour of the day down the side. Each hour I specify what I am doing that hour. What I want to do is make this into a chart to show the % of time I spend doing each activity in the overall week.

    Anyone know how I could do this? I have tried but can't get it to work.

    Thank You!

  2. #2
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    493
    Hi iAaron,

    Please see the attached sample chart.
    Attached Files Attached Files
    Corine

  3. #3
    Registered User
    Join Date
    05-13-2007
    Posts
    4
    Thanks. I tried doing it the same way though and I still can't get it working?

    I've made a quick example of what I'm working with. I need it to show the % of time each activity takes up over the week. I've attached it to the post.

    Thanks alot. Aaron
    Attached Files Attached Files

  4. #4
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    493
    Hi iAaron,

    See the attached file, sheet 2.

    I made a data sample, and made some formula to compute for the percetage of activity per day.

    The formula used is:
    Please Login or Register  to view this content.
    which in a day = 5 hours, example in Monday, your football activity totals to 2, so 2/5 = 0.4 or 40% (make the cell category to percentage)

    copy the formula down and accross then plot the graph.

    I hope it helped you get started.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-13-2007
    Posts
    4
    Ah, got it. Thanks for your help!

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote Originally Posted by corinereyes
    Hi iAaron,

    See the attached file, sheet 2.

    I made a data sample, and made some formula to compute for the percetage of activity per day.

    The formula used is:
    Please Login or Register  to view this content.
    which in a day = 5 hours, example in Monday, your football activity totals to 2, so 2/5 = 0.4 or 40% (make the cell category to percentage)

    copy the formula down and accross then plot the graph.

    I hope it helped you get started.
    Hi corinereyes,

    Just a little typo, you are playing Football and Footaball, or should it be Soccer? Also shouldn't it be
    Please Login or Register  to view this content.
    so that the total for the day adds up to 100% not 120%
    Last edited by oldchippy; 10-21-2007 at 02:40 PM.
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  7. #7
    Forum Contributor corinereyes's Avatar
    Join Date
    12-02-2003
    Location
    Philippines
    MS-Off Ver
    MS Excel 2003, MS Excel 2007
    Posts
    493

    Thumbs up

    Hi oldchippy,

    Football (lol!). Perfect oldchippy! thanks for the correction.

    The total activity is 6 so it should be divided by 6, total is 100%.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1