TIMEVALUE function

Description

TIMEVALUE(str) converts a time string (in "hh:mm" format) to a serial time number. A serial time number is a number ranging from 0.00 to 1.00 representing the time 0:00 to 24:00.

Examples

TIMEVALUE("06:30") returns 0.27084

TIMEVALUE("12:00") returns 0.5

Calculator

Related functions

• TIME function
• List of Date and time functions