Formulas and Functions

SECOND
The SECOND function returns the seconds for a given date/time value.
SECOND(time)
 time: The time the function should use. time is a date/time value. The date portion
is ignored by this function.
Example
=SECOND(”4/6/88 11:59:22 am”) returns 22.
Related Topics
For related functions and additional information, see:
“DAY” on page 47
“HOUR” on page 51
“MINUTE” on page 52
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
TIME
The TIME function converts separate values for hours, minutes, and seconds into a
date/time value.
TIME(hours, minutes, seconds)
 hours: The number of hours to include in the value returned. hours is a number
value. If hours has a decimal portion, it is ignored.
 minutes: The number of minutes to include in the value returned. minutes is a
number value. If minutes has a decimal portion, it is ignored.
 seconds: The number of seconds to include in the value returned. seconds is a
number value. If seconds has a decimal portion, it is ignored.
Usage Notes
You can specify hour, minute, and second values greater than 24, 60, and 60, Â
respectively. If the hours, minutes, and seconds add up to more than 24 hours, 24
hours are repeatedly subtracted until the value is less than 24 hours.
56 Chapter 3 Date and Time Functions