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
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