Date stamp - Zulu time

[trevolly]

Hi all,

Im wondering if it is possible to ask for help with current time in a cell and zulu time in my area (-1 hour)

I work at an airport and we type a daily log, with the time being entered in zulu. I have found a vbr code to enter the current time in a cell when I double click but its in local time (+1 hour of zulu). Is this possible?

This is the vbr code I'm using atm.

Thank you all


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified 4-28-18 5:40 PM EDT
If Not Intersect(Target, Range("B4:B218")) Is Nothing Then
Cancel = True
Target.Value = Now()
End If
End Sub

 

[GWteB]

Try

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim zulu As Date
    If Not Intersect(Target, Range("B4:B218")) Is Nothing Then
        Cancel = True
        zulu = Now() - TimeValue("01:00:00")
        Target.Value = zulu
    End If
End Sub

 

[trevolly]

Thank you v much..... why did I volunteer to make a new daily log sheet!! I've got an even harder task ahead!!

 

[GWteB]

You are welcome!