Home |
Search |
Today's Posts |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
How can I insert current system time, but offset by 1 hour?
Why are you so bound and determined to get an answer here when you've
already gotten two answers in another NG? If you persist, you'll only get the same answers here, as this NG is read by pretty much the same people. But just to prove that I can be helpful, here are some answers for you: See http://www.gmayor.com/insert_a_date_...than_today.htm and particularly the link there to http://www.gmayor.com/downloads.htm#Third_party Selection.InsertAfter "The time: " & Format(Time, "h:mm") & _ vbCr & "The time an hour ago: " & _ Format(DateAdd("h", -1, Time), "h:mm") & vbCr & _ "The time an hour from now: " & Format(DateAdd("h", 1, Time), "h:mm") -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "scottalanclymer" wrote in message ... OK you're obviously the local forum cop. You realize you're single-handedly defeating the whole purpose of the forum which you patrol? This is all here for information. Education. Solving problems. You're doing the opposite. You're creating a problem and ignoring the original question entirely. I really feel sorry for the people in your life that have to put up with you everyday. Your whole purpose is to find fault. Butt out if you can't address the thread. You keep wasting my time and I WILL unload on you. Go away. "Suzanne S. Barnhill" wrote: Yes, I see now that the header on that post does say ""scottalanclymer" wrote in message ," but WordBanter (whatever that is), is obviously just a pipeline to the Microsoft newsgroups on Usenet, and it appears in the newsgroup I cited. Graham Mayor posted a reply there, to which you replied, and Greg Maxey posted a follow-up. Regardless of how you are posting, I am seeing all these postings on the Microsoft news server via NNTP. Most of us who post in these newsgroups do read several of them, and we don't distinguish the source of the posts, so your post in microsoft.public.word.tables and the identical one here in microsoft.public.word.newusers appeared to me to be duplicates (as in fact they were). Since you are posting here through the Microsoft Communities Discussion Groups, I suggest that you look in the list of discussion groups for the one labeled "tables," where you will find your duplicate post. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "scottalanclymer" wrote in message ... I posted it on WordBanter. Never heard of "microsoft.public.word.tables". Don't know what it is. Don't want to know what it is. I'm not here to understand forums. I'm here to try and get a simple answer. If you're more into interrogating new users, sorry. I'm not here for that. If you have any help, it would be appreciated. "Suzanne S. Barnhill" wrote: Are you not the person who posted this message in microsoft.public.word.tables, under the screen name "scottalanclymer," at 8:22 PM CST yesterday? "Have been using Word to edit my webpage. Have 5 timezones I want to automatically update the stamp every time I open the file. See it at home comcast net ~scottalanclymer. I think the method I'm currently using is considered a table. It's a snippit of a few columns and rows from excel using the formulas I already had there in my daily worksheet. But every time I open my page in Word to update it, I have to right click the table, hit O, hit E, the table updates the formulas from the current system time. Then I hit escape. It creates an IMAGE of the table. Then I have to adjust the width or heighth of the image to make it look like it's close to being normal again. It's a pain. I'd rather be able to write the code in Word, 5 lines, utilizing the time/date function, with offsets for the hours I need, I already have the math done on that, and have all 5 lines update with no work on my part each time I open the file for editing. Any takers on this challenge?" -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "scottalanclymer" wrote in message ... This is the first time I've ever posted on this site. I'm just looking for help on the question. There's 1 reply, it's you telling me I asked twice. I did not. Is there help to be found here, or is it just hassle? "Suzanne S. Barnhill" wrote: Please see replies to your previous duplicate question. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "scottalanclymer" wrote in message ... Have been using Word to edit my webpage for a couple years now. Have 5 timezones I want to display and automatically update every time I open the file to show when the page was last updated. See it at home comcast net ~scottalanclymer. I think the method I'm currently using is considered a table. It's a snippit of a few columns and rows from excel using the formulas I already had there in my daily worksheet. It is based on the premise that 1 hour = 0.041666666666666666666666666666667 of a day. The math is very simple. It's just 1/24 to extract the decimal value of 1 hour. But every time I open my page in Word to update it, I have to right click the table, hit O, hit E, the table updates the formulas from the current system time. Then I hit escape. It creates an IMAGE of the table. Then I have to adjust the width or heighth of the image to make it look like it's close to being normal again. It's a pain. I want to flush the whole Excel table method, and be able to write the code in Word, 5 lines, utilizing the time/date function, with offsets for the hours I need. The goal is to have all 5 lines update with no work on my part each time I open the file for editing. My question in it's simplest form is: How can I insert the date+time in a Word document, but offset by 1 hour? . . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i insert an offset date in word | Microsoft Word Help | |||
how do I display the current date and time on Microsoft Office? | Microsoft Word Help | |||
Need system restores to open Word each time. Solution? | Microsoft Word Help | |||
Current date/time displayed | Mailmerge | |||
Word's current date is different from system date | Microsoft Word Help |