Get time from 24 hours format

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?


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

1 Like