Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu

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