Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Jane Jane is offline
external usenet poster
 
Posts: 87
Default Help with Time Calculation

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.
--
Jane M
  #2   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Help with Time Calculation

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/show...?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" wrote in message
...
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.
--
Jane M



  #3   Report Post  
Posted to microsoft.public.word.tables
Jane Jane is offline
external usenet poster
 
Posts: 87
Default Help with Time Calculation

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


"Doug Robbins - Word MVP" wrote:

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/show...?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" wrote in message
...
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.
--
Jane M




  #4   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Help with Time Calculation

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" wrote in message
...
Doug: how do I get the excel speadsheet into the word document.
--
Jane M


"Doug Robbins - Word MVP" wrote:

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/show...?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" wrote in message
...
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.
--
Jane M






  #5   Report Post  
Posted to microsoft.public.word.tables
Jane Jane is offline
external usenet poster
 
Posts: 87
Default Help with Time Calculation

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


"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
Doug: how do I get the excel speadsheet into the word document.
--
Jane M


"Doug Robbins - Word MVP" wrote:

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/show...?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" wrote in message
...
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.
--
Jane M






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Built-in time interval calculation in a Word file? Puzzled57 Microsoft Word Help 1 February 10th 07 09:39 PM
Format Date and Time to show Military Time AlanFD Microsoft Word Help 2 September 22nd 06 10:44 PM
tax calculation in a form old spice Microsoft Word Help 2 August 9th 06 07:06 PM
Calculation ll Tables 4 May 9th 05 01:29 PM
Calculation LindaCoedy Tables 4 November 4th 04 04:24 PM


All times are GMT +1. The time now is 08:43 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"