In a table each day of the week needs a drop down list content control for hours. I.E.


0.15
0.50
0.75
1.00
1.15
1.50
1.75
2.00
2.15
etc. up to 5 hours

I could do it as regular list but I want to make two additional things happen once a day's hours were selected. Assume Mon was 1.15 hours, Tue 0.15 and Wed 2.15 hours. First it would be good to get a grand total automatically for the week of all hours. However each day will also have an activity associated with the hours so Mon might be skating , Tue treadmill, Wed skating again. I also want to total all hours for each activity for that week. So the week above would have a total of 3.45 hours and skating 3.30 hours. Maybe I would show these total weekly hours by activity in a separate table. I thought of using Excel but the students are know Word 2010 better than Excel. Any suggestions?

Yes, this could be done in Word (it would require the use of macros), but Excel is far better suited to this (no macros required) and it would be much better to expose the students to Excel than to do it in an application not designed for that purpose.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Ok. I agree Excell can do this better. Guess I'll have to teach basic excel. Thanks for the suggestion.