So I created a little timestamp Macro and assigned a shortcut to help me when documenting on the fly
My PC is set to Eastern Time zone, but I would like the time that's generated by the macro to be Mountain Time.Sub TimeStamp()
'Inserts current date
Selection.InsertDateTime DateTimeFormat:="hh:mm AM/PM ", InsertAsField:=False
lbl_Exit:
Exit Sub
End Sub
How would I change the code to do so?
(I know it would a lot easier if I just change the time zone setting on the PC itself, but I'm in a environment that doesn't allow that, and I have no pc admin previllages.)
Bookmarks