@Time (Formula Language)

Translates numbers for the various components of time and date; then returns the time-date value.

Syntax

@Time( hour ; minute ; second ) @Time( year ; month ; day ; hour ; minute ; second ) @Time( time-date )

Parameters

year

Number. The year.

month

Number. The month.

day

Number. The day.

hour

Number. The number of hours you want to appear in the resulting time.

minute

Number. The number of minutes you want to appear in the resulting time.

second

Number. The number of seconds you want to appear in the resulting time.

time-date

Time-date or time-date list. For a time-date value such as @Now or [10/31/93 12:00:00], @Time removes the date portion of the value, leaving only the time.

Return value

truncatedTimeDate

Time-date. The time corresponding to the parameters you sent to @Time, minus any date components if the parameter is time-date.

Usage

If the first 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.

Examples

  1. This example returns 4/11/51 11:50:30 PM.
    @Time(1951;04;11;23;50;30) 
  2. This example returns 12:00 PM and 01:00 PM in a list.
    @Time([10/31/93 12:00:00] : [10/31/93 13:00:00])
  3. This example returns 09:19:24 AM at 9:19:24 A.M on any day.
    @Time(@Now)
  4. This example returns 09:19:24 AM if 9:19:24 A.M is the time the document was created.
    @Time(@Created)