Word 2010 drop down control list for hours with cumulative and individual totals
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?
Last edited by Charles Kenyon; 01-19-2016 at 07:46 AM.
Reason: changed title to give more info - mark as solved
|