Feb 15 2024 12:24 PM
07:42 |
is the example of the time format and am looking to convert it to decimal point format of 7.42
Feb 15 2024 01:22 PM
Shouldn't 07:42 be converted to 7+42/60 = 7.7 ?
Feb 15 2024 03:00 PM - edited Feb 15 2024 03:35 PM
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.