Documentation/How Tos/Calc: TIMEVALUE function

CALC FUNCTIONS

Date & Time Functions

< Previous Section

Next Section >

FUNCTIONS

• Today
• Now
• Year
• Month
• Day
• Weekday
• Hour
• Minute
• Second
• Date
• Datevalue
• Time
• Timevalue
• Eomonth
• Edate
• Workday
• Networkdays
• Days
• Days360
• Daysinmonth
• Daysinyear
• Weeks
• Weeksinyear
• Weeknum
• Weeknum_add
• Months
• Years
• Isleapyear
• Eastersunday
• Yearfrac

< Previous Page

Next Page >

TIMEVALUE

returns the date-time serial number, from a time given as text.

Syntax:

TIMEVALUE(timetext)

timetext is a time, expressed as text.

TIMEVALUE returns the date-time serial number, which may be formatted to read as a time.

Example:

TIMEVALUE("16:48:00")

returns 0.7, the date-time serial number for 16:48:00. This may be formatted to read, for example, 4:48 PM.

---

See Also

• TIME
• DATEVALUE

• Date & Time overview

• Date & Time functions

• Functions listed alphabetically
• Functions listed by category