Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Built-in time interval calculation in a Word file? | Microsoft Word Help | |||
Format Date and Time to show Military Time | Microsoft Word Help | |||
tax calculation in a form | Microsoft Word Help | |||
Calculation | Tables | |||
Calculation | Tables |