Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-07-2010, 06:38 AM
SteadyWord SteadyWord is offline Convert Timestamp to GMT Time Windows XP Convert Timestamp to GMT Time Office 2007
Novice
Convert Timestamp to GMT Time
 
Join Date: Jun 2010
Posts: 1
SteadyWord is on a distinguished road
Default Convert Timestamp to GMT Time

Greetings all,
I have a Macro I created to insert the current date time and it works well. It inserts the time for my local time (US CST/CDT), what I am trying to do is get this timestamp to add GMT Time instead of my local time. GMT Time for me is currently CST + 6 hours.

This is my current macro:

Code:
Sub Timestamp()
'
' Timestamp Macro
'
'
    Selection.InsertDateTime DateTimeFormat:="M/d/yyyy h:mm am/pm", _
        InsertAsField:=False, DateLanguage:=wdEnglishUS, CalendarType:= _
        wdCalendarWestern, InsertAsFullWidth:=False

End Sub
Any assistance would be appreciated.
Thanks
Wally
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Timestamp to GMT Time Convert PDF to PPT? Hinmini PowerPoint 1 10-28-2011 07:38 PM
Convert JML files Lundberg Word 5 09-11-2010 11:05 AM
Convert Timestamp to GMT Time help to convert swf to avi for displaying in ppt? Frederick PowerPoint 1 09-13-2009 08:10 PM
convert golden039 Word 0 08-16-2009 05:48 PM
Timestamp for notes in contacts? boe Outlook 2 11-30-2005 04:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft