The HOUR() document very specifically states to use this formula to get the hour from NOW()
HOUR(TIME(NOW()) - "00:00:00")
But this still does not work??? Any help here
Could you elaborate?
In my testing it works as intended.
Column [Current_Time_Hour] expression is as follows:
HOUR(NOW() - "00:00:00")
This formula subtracts the time "00:00:00" (midnight) from the current time using the minus operator ("-"), and then the HOUR() function extracts the hour component from the resulting duration.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |