TIMEFRAC function
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
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.
TIMEFRAC("12:30") returns 12.5