% Of Time Spent Over A Week...

**iAaron** · 10-21-2007, 11:06 AM

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!

**corinereyes** · 10-21-2007, 11:16 AM

Hi iAaron,

Please see the attached sample chart.

**iAaron** · 10-21-2007, 11:56 AM

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

**corinereyes** · 10-21-2007, 12:27 PM

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.

**iAaron** · 10-21-2007, 12:30 PM

Ah, got it.

Thanks for your help!

**oldchippy** · 10-21-2007, 02:36 PM

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%

**corinereyes** · 10-21-2007, 02:45 PM

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

% Of Time Spent Over A Week...

LinkBack

Thread Tools

Rate This Thread

Display

% Of Time Spent Over A Week...

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions