I have a macro : trigger when the time between 5 to 18,
but my system time is 12 hours format, how can the macro get the system time with 24 hours format?
thanks.
I have a macro : trigger when the time between 5 to 18,
but my system time is 12 hours format, how can the macro get the system time with 24 hours format?
thanks.
The HOUR function returns the current time in 24-hour format (0-23).
So that calculation would be
5 < HOUR() AND HOUR() < 18
Which would be between 6:00am and 6:00pm