Getting HOUR from TIMENOW()

[Dan_Oliphant]

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

[Suvrutt_Gurjar]

Could you elaborate?

In my testing it works as intended. 

Column [Current_Time_Hour] expression  is as follows:

[Sirfyaad]

@Dan_Oliphant 

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.