How can I insert current system time, but offset by 1 hour?

  • Thread starter Thread starter scottalanclymer
  • Start date Start date
S

scottalanclymer

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?
 
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?
 
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
 
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.
 
Yes, I see now that the header on that post does say ""scottalanclymer"
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
 
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.
 
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_other_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
 
Who is defeating the purpose here? Your question was answered yesterday, yet
you ask it again and hassle those who point you to it?

Did you actually read the link I posted in response to your earlier
question? You have clearly seen the reply and Greg Maxey has responded to
your further question - though the solution was already available in the
link I posted.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Do you think we want to answer the same question repeatedly everywhere you
decide to post it? You have had your answer to your other post.

Be happy that you got FREE support in a timely manner by unpaid peers. YOU
are being unreasonable, unappreciative and thoroughly unpleasant.
 
You all think what you want. I got what you THINK are answers, but the answer
is not in what you gave. You didn't GET the question. And it's not about
giving reference material. Is that what you do when someone asks a specific
question? You give them a set of encyclopedias and wish them luck? I don't
have the time to read through all that. I have not the goal of knowing all
there is to know on Word. What is with you people? You think everyone is like
you, got nothing to do except sit around pretending to be sophisticated. I
have no more time for you people. Apparently you're all in the same basket.
You can all go **** yourselves. You can **** yourselves till you bleed. What
do I have to say to get banned here? GO **** YOURSELVES PEOPLE!!!!!!! ENJOY
YOUR ****ED UP LIVES! ENJOY YOUR OWN PERCEPTION THAT YOU'RE SMART. LIVE IT UP
DEUCHEBAGS!
 
Back
Top