TIMEVALUE

The TIMEVALUE function returns the time as a decimal fraction of a 24-hour day for a given date/time value or time string.

TIMEVALUE(time)

time: The time string to be converted or a date/time value.

Examples
=TIMEVALUE(“4/6/88 12:00”) returns 0.5 (noon represents one-half of the day). =TIMEVALUE(“12:00:59”) returns approximately 0.50068287037037. =TIMEVALUE(“9:00pm”) returns 0.875 (21—because 9:00 p.m. is the 21^st hour in 24-hour format—divided by 24).

Examples

=TIMEVALUE(“4/6/88 12:00”) returns 0.5 (noon represents one-half of the day).

=TIMEVALUE(“12:00:59”) returns approximately 0.50068287037037.

=TIMEVALUE(“9:00pm”) returns 0.875 (21—because 9:00 p.m. is the 21^st hour in 24-hour format—divided by 24).