Formulas and Functions

Chapter 3 Date and Time Functions 57
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.
Related Topics
For related functions and additional information, see:
“DATE” on page 44
“DATEVALUE” on page 47
“DURATION” on page 70
“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
TIMEVALUE
The TIMEVALUE function returns the time as a decimal fraction of a 24-hour day from a
given date/time value or from a text string.
TIMEVALUE(time)
 time: The time the function should use. time is a date/time value. The date portion
is ignored by this function.
Examples
=TIMEVALUE(”4/6/88 12:00”) returns 0.5 (noon represents one-half of the day).
=TIMEVALUE(”12:00:59”) returns 0.5007 (rounded to four decimal places of accuracy).
=TIMEVALUE(”9:00 pm”) returns 0.875 (21 hours, or 9:00 p.m., divided by 24).
Related Topics
For related functions and additional information, see:
“Listing of Date and Time Functions” on page 42