Tanh, Time – Apple Numbers '08 User Manual

Page 281

Advertising
background image

Chapter 12

Dictionary of Functions

281

TANH

The TANH function returns the hyperbolic tangent of the specified number.

TANH(number)

 number: Any number.

TIME

The TIME function converts hours, minutes, and seconds into a time format.

TIME(hours, minutes, seconds)

 hours: The number of hours (using a 24-hour clock).
 minutes: The number of minutes.
 seconds: The number of seconds.

Notes
You can specify hour, minute, and second values greater than 23, 59, and 59,
respectively. If the hours, minutes, and seconds add up to more than 24 hours,
Numbers subtracts 24 hours repeatedly until the sum is less than 24 hours.

You can also specify fractional values for hours, minutes, or seconds.

To convert a time that is a string, use the TIMEVALUE function.

Examples

TANH(0) returns 0.

TANH(1) returns 0.762.

TANH(5) returns 0.999909.

TANH(10) returns 0.999999996.

Examples

TIME(12, 0, 0) returns 12:00 PM.

TIME(16, 45, 30) returns 4:45 PM.

TIME(0, 900, 0) returns 3:00 PM.

TIME(60, 0, 0) returns 12:00 PM.

TIME(4.25, 0, 0) returns 4:00 AM.

Advertising