Help with Time Calculation

[Jane]

I have an agenda in a table format. I need the CellA1(Start Time)i.e. 8:30
a.m. + CellA2(Duration) i.e. 45 minutes to calculate together and put the
answer in CellB1 I would then enter the next duration in CellB2 and the
answer would go into CellC1 and so on till the end of the agenda (sometimes 2
or 3 pages long). I will also need to use the Alt+Shift+Arrow up or Down to
move items, and when moved the startTime of the calculation would change to
reflect the moved item. I have looked at the Template in Word Agenda Wizard
and the layout will not work for our Council Meetings as it has only duration
and no start time for each item. I would appreciate any help, suggestions
or advise anyone can give me. Many Thanks.

 

[Doug Robbins - Word MVP]

The easiest thing to do would be to insert an Excel spreadsheet into the
Word document. You can then use all of the calculation functionality
available in Excel. Except when you are actually working in that
spreadsheet, it will be indistinguishable from a Word table.

Alternatively, if you are hell bent on doing it in Word alone, to see how to
do
this and just about everything else you might want to do
with dates in Word, check out fellow MVP, Macropod's Date Calc 'tutorial',
at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

or at the following page of fellow MVP Graham Mayor's website

http://www.gmayor.com/downloads.htm#Third_party

where he has an item titled 'Date and Time Calculations In A Mailmerge'

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jane]

Doug: how do I get the excel speadsheet into the word document.

 

[Doug Robbins - Word MVP]

Use the Insert Excel Spreadsheet button from the Standard Toolbar.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jane]

Many thanks for all you help. I will give it a try.