How do I add system time zone to a time stamp, i.e. if my PC is set to EST then add (EST) at end of result of below code?
Better yet, if my PC is set to (UTC-7) for example, how do I have the code adjust to EST and produce EST result?
Better yet, if my PC is set to (UTC-7) for example, how do I have the code adjust to EST and produce EST result?
VBA Code:
Sub LatestSaved()
Dim LS As String
LS = "Latest updated: " & Format(Now(), "ddd, mm.dd.yy - hh:mm")
Sheet1.Range("B3").Value = LS
End Sub