@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
- This example returns 4/11/51 11:50:30 PM.
@Time(1951;04;11;23;50;30) - 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]) - This example returns 09:19:24 AM at 9:19:24 A.M on any day.
@Time(@Now) - This example returns 09:19:24 AM if 9:19:24 A.M is the time the
document was created.
@Time(@Created)