Hi
I have a cell with a timestamp in this format
and I declared this
So if I want do something for example every 20 mins from 11:00 to 20:00 I can write different IFs
My questions is:
is that syntax correct?
is there a cleverest way?
thanks
I have a cell with a timestamp in this format
this cell updates itself dynamically and it is in Sheet1 E111:34:31
and I declared this
so I will start from 11, and if I'm not wrong withApplication.OnTime TimeValue("11:00:00"), "mySub"
I have the current time.
So if I want do something for example every 20 mins from 11:00 to 20:00 I can write different IFs
If (Now = 11:20) Then
..
EndIf
If (Now = 11.40) Then
..
EndIf
If (Now = 12:00) Then....
...
My questions is:
is that syntax correct?
is there a cleverest way?
thanks