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

TIMEVALUE()

Related functions

This site uses cookies to store information on your computer. More info...