Forum Discussion
Converting numbers in decimal to hours & minutes
How can I convert the numbers I have with 2 decimal places to hours:minutes?
To convert 17.80 in A1 to 17.48, use the formula =DOLLARFR(A1, 60)
To convert it to the real time value 17:48, use the formula =A1/1440 and apply the custom format [m]:ss to the cell with the formula.
Plus why/how somebody should arrive at the DOLLARFR function while doing calculations with time-dates values?
- On top of that one need also the inverting function of DOLLARFR (and again without doing double deadly jumps, why should I use a spreadsheet if I have to think of formulas 100 characters long?)