Convert Timestamp to GMT Time

SteadyWord · #1 06-07-2010, 06:38 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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