# % Of Time Spent Over A Week...

1. ## % 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. Hi iAaron,

Please see the attached sample chart.

3. 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

4. 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.

5. Ah, got it. Thanks for your help!

6. 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%

7. 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%.

##### Users Browsing this Thread

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

#### 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