TIMEFRAC function

Description

TIMEFRAC(time) converts time into fractional time-number. The integer part of this number is the hour, and the decimal fraction ranges from 0.0 to 0.99, representing the minutes 0:00 to 0:59.

Example

TIMEFRAC("12:30") returns 12.5

Calculator

Related functions

• List of Date and time functions