Apple Numbers '08 - Manual (Page 271)

Chapter 12 Dictionary of Functions 271
SECOND
The SECOND function extracts the seconds from a date.
SECOND(datetime)
 date-time: Any valid Numbers date or time value.
SIGN
The SIGN function returns 1 when the argument number is positive, –1 when it is
negative, and 0 when it is zero.
SIGN(number)
 number: The number you want to find the sign of. It can be a reference to a cell
containing a number.
SIN
The SIN function calculates the sine of an angle in radians.
SIN(radian-angle)
 radian-angle: The angle in radians.
Notes
If you measure angles in degrees instead of radians, you can use the RADIANS function
to convert degrees to radians for the SIN function.
If you want to express radians as a multiple of pi, you can use the PI() function to
provide a value for pi.
Examples
SEARCH("ra", "abracadabra") returns 3; the first occurrence of the string "ra" starts at the third
character in "abracadabra".
SEARCH("ra", "abracadabra", 5) returns 10, the position of the first occurrence of string "ra" when you
start looking at position 5.
Examples
SECOND("4/6/88 11:59:22 AM") returns 22.
Examples
SIGN(2) returns 1.
SIGN(0) returns 0.
SIGN(-2) returns -1.
SIGN(A4) returns -1 if cell A4 contains -2.