@Hour (Formula Language)

Returns the number of the hour in the specified time-date.


@Hour( timeDateValue )



Time-date or time-date list. The value with the hour that you want to extract.

Return value


Number or number list. A number representing the hour contained in timeDateValue. Hours are represented as 0 through 23 for 12 AM through 11 PM. Returns -1 if the time-date provided contains only a date and not a time value.


If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.


  1. This example returns 9.
  2. This example returns 9 and 10 in a list.
    @Hour([9:30] : [10:30])
  3. This example returns 8 if the time in the Date field is 8:56:34 AM.
  4. This example returns 20 if a Date field is made up of the date and time: 7/30/90 8:56:34 PM.
  5. This example returns 3 if the current document was created on 2/15/92 at 3:00:12 A.M.