Manual

Time and Date Functions
Spreadsheet uses serial numbers to represent times and dates. The serial
numbers begin with 1 = January 1, 1900. The DATE and DATEVALUE
functions return the serial number for a given date.
Function
DATE (year, month,
day)
DATEVALUE
(string)
DAY (date value)
HOUR (time value)
MINUTE (time
value) _ _
MONTH (date
value)
NOW( )
SECOND (time
value)
b
Description
Converts a numeric date (day, month, year) to the serial number format. Year
can be from 1900 to 2078. For the years 1900 to 1999, you can enter just the last two
digits, for example 96 rather than 1996. Month can be 1-12. Day can be a value from
1-31, depending on the number of days in month. If you useyear, month, or day
values that are out of range, DATE returns #VALUE#.
Converts a date (in text form) to the serial number format
Extracts the day from the serial number format. Date va/ue must be a serial
number. Use DATEVALUEto convert dates entered as labels.
Returns the hour of the day from time va/ue serial number. You can use
TIMEVALUE to convert text time. The hour is an integer from 0 to 23. Time serial
numbers are decimal fractions and can be part of a date/time combination. If there is
no fractiona| part, the time is midnight.
Extracts the minute from the time value serial number. The minute is an integer
from 0 to 59. Time seri!!, numbers are decimal fractions and can be part of a
date/dme-combinationyJf_-_ is nO fractional part, the time is midnight. You .can
use TIMEVALUE t@convert text time.
Extracts the month from the date va/ue serial number. Month is an integer from
1 to 12. Timeserial numbers are decimal fractions and can be part of a date/time
combination. If there is no fractionalpart,the time is midnight. Use DATEVALUEto
convert dates entered as labels.
Returns the current date (month, day, and year) and time (hour, minute, and
second). You must enter the empty parentheses. The whole number represents the
date as a serial number starting January 1, 1900. The decimal fraction portion of the
number represents the time, beginning at midnight = 0. You must include the empty
parentheses.
Extracts the second from the time va/ue serial number. The second is an integer
from 0 to 59. Time serial numbers are decimal fractions and can be part of a
date/time combination, ff there is no fractional part, the time is midnight. You can
use TIMEVALUE to convert text time:
TIME (hour, minute, Converts a numerical time (hour, minute, and second) to the serial number
second) format
TIMEVALUE Converts a time (in text format) to the serial number format
Appendix 226