% Of Time Spent Over A Week...

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

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, 12:16 PM

Hi iAaron,

Please see the attached sample chart.

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

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, 01: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:

Code:

=SUMPRODUCT(--(B$2:B$7=$A10))/5

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, 01:30 PM

Ah, got it.

Thanks for your help!

**oldchippy** · 10-21-2007, 03: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:

Code:

=SUMPRODUCT(--(B$2:B$7=$A10))/5

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

Code: