TIMEVALUE

Returns the fraction of a 24-hour day the time represents.

Sample Usage

TIMEVALUE("6:00 PM")
TIMEVALUE(C5)

Syntax

TIMEVALUE(time_string)

  • time_string - The string containing the time value.

Examples

TIMEVALUE("6:00 PM") returns the fraction of a 24-hour day the time represents. Here, it returns 0.75.
TIMEVALUE(C5) returns the fraction of a 24-hour day represented by the time string in cell C5.

Notes

  • The string of text used in time_string should be within quotations and represent time using either the 12-hour or 24-hour time format, for example "2:15 PM" or "14:15".
  • TIMEVALUE returns a number between 0 (inclusive) and 1 (exclusive).