How to convert time format to a decimal format that will allow conditional formatting.

[ROPA038]

07:42

is the example of the time format and am looking to convert it to decimal point format of  7.42

[#2]

@ROPA038 

Shouldn't 07:42 be converted to 7+42/60 = 7.7 ?

[#3]

@ROPA038 

The reasoning behind this is something of a mystery to me but, taking the request at face value,

= DOLLARFR(24*time,60)

will perform the requested conversion and (if it all turns out to be a mistake?)

= DOLLARDE(+decimal,60) / 24

will revert the values to time.