Hi @CANA-IT
Here is the answer probably to your question, along with its solution: HOUR() - AppSheet Help
Common problems
HOUR(NOW()) (or any DateTime or Time value in place of NOW()) causes Expression Assistant to complain, Parameter 1 of function HOUR is of the wrong type. The argument must be a Duration value, not a DateTime or Time value. To fix, convert a DateTime value to a Time value with TIME(), then subtract a zero time to convert a Time value to a Duration value: HOUR(TIME(NOW()) - "00:00:00"). See also: [NOW()](https://support.google.com/appsheet/answer/10108119), [TIME()](https://support.google.com/appsheet/answer/10107367)