#1
|
|||
|
|||
Form Driven Date/Time Calculations
First off, I hope I'm in the correct forum!
Problem statement: I currently maintain a document that contains dates and times scattered throughout the document. These dates and time can be repeated in multiple sections of the document. Updating this document for each activity is tedious and prone to error. Question: Is there a way I can update a table or form within the document and have it calculate 3 different time zones and auto-populate multiple sections of the document? Sorry, I know this probably opens the door to many questions and there may be several options that can handle this. I would love your advice and direction but would also be interested in any publication that's has good direction in this area. Thanks in advance! Dnunnally |
#2
|
||||
|
||||
You only need to enter each date or time once then see http://gregmaxey.com/Repeating_Data.htm for an assortment of ways of reproducing the date/time elsewhere.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
||||
|
||||
If you need to do time calculations as well, see Add n Hours, Minutes & Seconds To a Starting Date & Time in my Microsoft Word Date & Time Calculation Tutorial, which you can download from:
http://windowssecrets.com/forums/sho...ation-Tutorial or: http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Thanks For the Direction!
Thanks folks! I will look into each suggestion provided. I'll report back with comments and/or question soon. Thanks! dnunnally
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Real Time calculations | wgutshall | Excel | 3 | 07-10-2015 08:44 AM |
Restrict Date Range Calculations | akatz85 | Excel | 4 | 03-27-2014 08:46 PM |
Word form w/ autopopulated date/time | Dendalee | Word | 1 | 10-24-2012 11:40 PM |
Date driven value | ronocoo | Excel | 7 | 05-24-2011 11:03 PM |
Calculations using values from date picker controls | Inkarnate | Word | 0 | 06-09-2010 07:16 AM |