Forum Discussion
How to convert time format to a decimal format that will allow conditional formatting.
| 07:42 |
is the example of the time format and am looking to convert it to decimal point format of 7.42
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) / 24will revert the values to time.
Shouldn't 07:42 be converted to 7+42/60 = 7.7 ?
