Get time from 24 hours format

I have a macro : trigger when the time between 5 to 18,
image
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

1 Like